Transfer Text Error

  • Thread starter Thread starter LJG
  • Start date Start date
L

LJG

I have a Macro to import data to a table from a text file.

However, I keep getting a error message:

importImportIBDMembers

True

TransferText

0, IBDTeamUpdate Import Specification, tblIBDteam,
C:\database\tableupdates\IBDTeamUpdate.txt, Yes, ,

then gives me a runtime error 2391

Field "orgID" does not exist in the destination table 'tblIBDTeam'

The field does exist and I have used the same process for a number of other
macros all that work fine? Any suggestions on were to look for a problem

TIA

Les
 
Les,

The first thing I would do here is run through the process manually, via
the File|Get External Data menu, and re-save the Import Specification.
See if that helps.
 
Back
Top