Delimited fields imported to one column in access
I tried to import a text file(tab delimited) into an access database, through vba. the command is docmd.transfertext
However, after import i found that all the fieds in the input file, were being imported into one single column of an access table. I searched in google and saved a specification file. Now the import was successful.
But when i have multiple textfiles to be imported, with different number of fields, i cant use the same import specification. So i have to create a new import specification for each file. But that is cumbersome.
By using ADO, i could have done it, but it is lot of code, to find out the number of fields in the input file and then create a table with the same no of fields and then append data to the table.
Please let me know, if this can be handled differently using the docmd.transfertext command.
Can a single import spec be created for all the files