Transfer a text file

[Guest]

I am transfering a Comma delimited text file with text qualifier ". I created
an import specification and when I run the import manually it works fine.
When I set up a macro to run it, however, All the numeric fields come over
fine, but the text fields come over with the text qualifier around the actual
text.

For example, if the text field has a value of AMB01 it is imported as "AMB01".
How can I set this up to make sure that the text qualifier does not get
imported with the data?

Any help would be appreciated

 

[Ken Snell [MVP]]

Are you using the import specification that you created in the ImportSpec
argument for the TransferText action?

 

[Guest]

Ken,
Yes I am. I am assuming that you mean in the Macro.

 

[Ken Snell [MVP]]

Post the details of the arguments of the TransferText action that you're
using. And double-check the import spec that it's showing that " is the text
qualifier. If you successfully use the import specification to manually
import the data as you desire, that same specification should also work with
TransferText in a macro.

 

[Guest]

Ken,
I apologize for taking this long to respong to you. I have had the flu and
was not up to snuff.

Here are arguments
Transfer Type: Import Fixed Width
Specification Name: acdlvr2 Import Specification
Table Name: acdlvr2
File Name: F:\Projects\acdlvr2.txt
Has Field Names: No

In the meantime I used the DoCmd method in a function and it seems to be
working. I would still appreciate if you can explain why the macro is not
working.

Also, is it possoble to copy these Import specifications into another
database?


Thanks

Anand