dapfeifer
Bringing Maverick Mojo
- Local time
- Today, 17:11
- Joined
- Jun 17, 2008
- Messages
- 68
Hey all,
I don't know if there is a way to help with this one, and it's going to be slightly vague in description, but I'm currently working on a database that imports a text file for its data. Problem is that sometimes it will import correctly and other times it will mess up like it is its job. I've tested through importing the same file and like I said sometimes it works and other times it doesn't.
I'm using a combination of a custom-built specification, VBA code and an SQL query to import the data to a table. From there, another query is run to strip out all the unnecessary data and move the "good" data into another table, from which I can then use in report, forms, etc.
Any suggestions on where to look or what to do to fix this? It seems the bigger the import file, the more likely it is to screw up (which seems logical i guess).
I don't know if there is a way to help with this one, and it's going to be slightly vague in description, but I'm currently working on a database that imports a text file for its data. Problem is that sometimes it will import correctly and other times it will mess up like it is its job. I've tested through importing the same file and like I said sometimes it works and other times it doesn't.
I'm using a combination of a custom-built specification, VBA code and an SQL query to import the data to a table. From there, another query is run to strip out all the unnecessary data and move the "good" data into another table, from which I can then use in report, forms, etc.
Any suggestions on where to look or what to do to fix this? It seems the bigger the import file, the more likely it is to screw up (which seems logical i guess).
