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
resource@pcdatasheet.com www.pcdatasheet.com
"Dan" <danmat347@hotmail.com> wrote in message
news:1142a0be.0312270915.31c9a361@posting.google.c om...[color=blue]
> 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 ![/color]
