VBA to Import Data from a tab delimited text file into certain fields of an access table automatically
Posted on 2004-04-30
I have a tab delimited text file with some data which I need to use to populate certain fields in a table in access by writting a macro in VBA. The data is not in the same order as the fields in the table. So, I was thinking would it be a beter approach to write a macro which read the text file and store each tab delimited data into a separate variables and then write the value of required variables in appropriate fields in the table.
I dont really want to create another temporary/intermediate table in access to write the data from the text file in teh same order and then insert the required value into the final table.
For Ex: Text file contains:
12345 achuyoo 25/0304 hjyuiii 458896 ICL 0 23/05/04 9
And we might need to store this data in the following manner in Access
FIELD1 FIELD2 FIELD3 FIELD4 FIELD5 FIELD6 FIELD7 FIELD8
12345 25/03/04 ICL 0 hjyuiii
THanks for helping me out here!!