By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,504 Members | 1,410 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,504 IT Pros & Developers. It's quick & easy.

Help with this Error Message

P: n/a
Dan
I can't figure out this error message. Could someone please help.
I have a text file in Notepad with the following 4 fields (Cont, Code,
List, and Numb)all of which are single tab delimited, and a bunch of
rows with values. I tried to create a macro (with the TransferText
action) that would automatically import the values from those fields
into an Access table called TestingTable which i created with the
exact same field names and text types as the text file.

Unfortunately, i get the following message when i run the Macro:

Field 'Cont_Code_List_Numb' doesn't exist in destination table
'TestingTable.'

For some reason the macro error message seems to be combining my
individual text file fields (Cont, Code, List, Numb) into one combined
field 'Cont_Code_List_Numb'.

I don't get this. Please help !
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Go to the database window and go to the tables tab. Go to File - Get External
Data. In the second dialog screen that comes up, click on Advanced. In the next
screen be sure that you have all the import parameters then save the import
spec. Back back out of all this to the database window. In your TransferText
procedure, enter the import spec parameter name you just saved. Now try your
TransferText procedure.
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"Dan" <da*******@hotmail.com> wrote in message
news:11**************************@posting.google.c om...
I can't figure out this error message. Could someone please help.
I have a text file in Notepad with the following 4 fields (Cont, Code,
List, and Numb)all of which are single tab delimited, and a bunch of
rows with values. I tried to create a macro (with the TransferText
action) that would automatically import the values from those fields
into an Access table called TestingTable which i created with the
exact same field names and text types as the text file.

Unfortunately, i get the following message when i run the Macro:

Field 'Cont_Code_List_Numb' doesn't exist in destination table
'TestingTable.'

For some reason the macro error message seems to be combining my
individual text file fields (Cont, Code, List, Numb) into one combined
field 'Cont_Code_List_Numb'.

I don't get this. Please help !

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.