Dear All,
I am using docmd.TransferText to import the data from a .txt
file into a msAccess table. The import specification specifies
17 fields to be imported. The problem is that sometimes I want
to import more than 17 fields and sometimes not. I do not know in advance what amount of fields I will get. If I have 17 fields specified in the specification it will only transfer the first 17 fields. If I don't specify an import specification in the docmd.TransferText function then it imports all fields but it puts them in one big field in the msaccess table. How can I dinamically import any amount of fields from a .txt file into a table and have them in seperate fields in the table.
Thanks,
Nathan
I am using docmd.TransferText to import the data from a .txt
file into a msAccess table. The import specification specifies
17 fields to be imported. The problem is that sometimes I want
to import more than 17 fields and sometimes not. I do not know in advance what amount of fields I will get. If I have 17 fields specified in the specification it will only transfer the first 17 fields. If I don't specify an import specification in the docmd.TransferText function then it imports all fields but it puts them in one big field in the msaccess table. How can I dinamically import any amount of fields from a .txt file into a table and have them in seperate fields in the table.
Thanks,
Nathan