Re: Problems with Transfer Text Action

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Steve Schapel (schapel_at_mvps.org.ns)
Date: 09/06/04 

Date: Mon, 06 Sep 2004 20:19:49 +1200

Steve

Run through the import wizard again, and when you get to the last sceen,
click the Advanced button, and save the set up as a Specification.
Then, nominate this specification in the Specification Name argument of
your TransferText macro. 

-- 
Steve Schapel, Microsoft Access MVP
Steve wrote:
> I am trying to load a .txt file into my access database 
> and am experiencing problems.  I load the file in via the 
> import wizard each day and have no problems, however, I 
> have not yet been able to do it successfully via a macro.
> 
> My setting are as follows:
> Transfer Type: Import Delimited
> Specification Name:
> Table Name: Declarations
> File Name: C:\Program Files\Raceform 
> Interactive\Export\Declarations.txt
> Has Field Names: No
> HTML Table Name:
> Code Page:
> 
> When I run the macro I get the following message:
> Field 'F1' doesn't exist in destination 
> table 'Declarations'.  Microsoft Office was unable to 
> complete the append operation.  The destination table 
> must contain the same fields as the table you are pasting 
> from.
> 
> Any ideas what I may be doing wrong ?  Remember, I have 
> no problems when importing manually.
> 
> Thanks in advance
> Steve
Quantcast