What is 'Field F1'?

  • Thread starter Thread starter Janet Ciegler
  • Start date Start date
J

Janet Ciegler

I have a short program in VB that is supposed to read a comma-delimited
text file from disk into an empty Access table. It works fine with my
Windows XP running Access 2000. However when I put the same Access 2000
onto a Windows 98 machine, the program fails, even though I’m using the
same input file, same table definition, and same code. The vb line is:
DoCmd.TransferText acImportDelim, , "tblImportText", strPathname
and the error message is:
Field ‘F1' doesn’t exist in destination table ‘tblImportText.’
Both input file and the table have exactly six fields. Sample input table:
4217,R,0006,002,001,00
4218,R,0006,004,002,00
4219,R,0006,004,004,01
4220,R,0006,004,005,00
When I use the regular method for importing (File–>Get External
Data->Import-> text file), that same file is imported correctly, but I
want to use a program. Any idea what is ‘Field F1' and what can I do
about it? Thanks for your help!
 
suggest you try using an Import Specification. set the Field names to match
the field names in your table.

hth
 
If you look in your original db, there is an import specification for the
transfer. It needs to be recreated, and then the transfer will work fine.
There is no automated /wizard way to transfer import specifications from one
db to another.

Marc
 
Marc said:
There is no automated /wizard way to transfer import specifications from one
db to another.
Click to expand...

Yes, there is. Open the new database and begin the Import process (File |
Get External Data ...| Import). Choose the database that has the
specification in it. Click OK in the window. When the wizard window opens,
at lower right of of screen, click Options >> button.
Click Import/Export Specs checkbox. Click OK.
 
Just out of curiosity, where is the Import Spec stored? I couldn't find
it on disk nor in Access. It works on my machine and will test it on
the other tonight. Thanks for all your help! Never would have figured
it out myself. Jan
 
It's stored in a system table in Access. System tables (which start msys)
are normally hidden, unless you go into Tools | Options and say that you
want to view them.
 
Back
Top