Transfer Text Error

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
 
S

Steve Schapel

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top