Using TransferText Macro Action to import

[Haritt]

I am trying to modify an existing macro that imports a
text file. It is using the TransferText action to
import. The Action Arguments are as follows:

Import Fixed Width
tblInventory Import Specification
tblInventory
X:\common......
No

I'm having problems finding the Specification file. I
need to import one additional column that is in the text
file into tblInventory.

Anyone have any ideas......

Thanks,
Haritt

 

[Mark]

Hi,

If you import the file in manually (using File>Get External Data>Import)
Select Text File in the Type of Files list
Select the file
Follow the Import Text Wizard instructions
Then press Advanced on the Import Text Wizard
And setup the revised import specification as required.

HTH

--

Cheers
Mark

Free Access/Office Add-Ins at:
http://mphillipson.users.btopenworld.com/