Import text file into access 2000 automatically not working

[Guest]

I have a dilemma I hope someone can help me with. I have an access db that
uses the "DoCmd.TransferText acImportDelim" to import a delimited file
"Contacts.txt" into the db as "table1". I modified "table1" by inserting new
fields into the table because the delimited data file has additional fields
added. The import process is an event procedure that is attached to a button
on my form.

This is the problem I encounter. The data imported into the table skips
over the new fields. It looks like the code does not understand that these
new fields exist in the table, and it skips over them and inserts the data in
the existing fields. The new fields are filled with zeros.

Please help. I have looked at the Access help and it seems that I will need
to create a "schema.ini" file or "specification name" to define these new
fields. How would I do this? Your imput is greatly appreciated. Thanks.

 

[Ken Snell [MVP]]

You create an import specification by doing the import process manually
(File | Get External Data ... | Import), selecting the file to be imported,
and then clicking the Advanced button (lower left) in the wizard window that
then opens. There you can set all the spec info and then save it as a spec
with a name.

 

[Guest]

Thank you so much. You have been a great help.

You create an import specification by doing the import process manually
(File | Get External Data ... | Import), selecting the file to be imported,
and then clicking the Advanced button (lower left) in the wizard window that
then opens. There you can set all the spec info and then save it as a spec
with a name.

 

[Ken Snell [MVP]]

You're welcome.

--

Ken Snell
<MS ACCESS MVP>

Thank you so much. You have been a great help.