HelloWorldGuy
MIS
I feel that the best way to explain this is with a little background. I was tasked with importing some .txt files into an Access database. The method I chose was to import the stripped data into a new .txt file and then into the database via DoCmd.transfer. This works great and I have no issues with it from a functionality standpoint. Now, the actual question. There is a previous method to do this in the database that I don't quite understand and curriosity is eating away at me! The previous method was to import the .txt file into a table with only one column, then by using a query and a VBA parse import it into a table. I can't quite replicate this process and it's driving me nuts! I know there are many ways to skin a data solution but any imput on how this works would be great! I have code samples available if you want. Thanks in advance!
