Import a txt file into table.

[turks67 via AccessMonster.com]

How do I fix this error "2391 Field 'F1' doesn't exit in destination" in
access when importing a txt file.
The table fields have names.

 

[ryguy7272]

Doesn't exit or doesn't exist? Sounds like the field that would be in
position F1 doesn't exist.

Look here:
http://support.microsoft.com/kb/142186

Also, look here:
http://www.caddetails.com/manufacturers/Tutorials/access.htm

I'll bet anything you are using VBA, to do the import. For now, try using a
macro for the import (it's a little easier that way):
http://www.access-programmers.co.uk/forums/showthread.php?t=41139

HTH,
Ryan--

 

[Piet Linden]

How do I fix this error "2391 Field 'F1' doesn't exit in destination" in
access when importing a txt file.
The table fields have names.

Create an import specification and use it when you do the TransferText.