Problem with Transfer Test

[Benji]

I am trying to automate the import of a text delimited file.
The file imports perfectly when I do it manually but when I set up a
Macro and run it I get "Field 'NoName' doesn't exist in the
destination table 'ImportData.'

There is no such field in the table I am trying to import from.

Also, is there any way to use wildcards when specifying the FileName?

Thank you for any help,

Ben

[Salad]

Benji wrote:

I am trying to automate the import of a text delimited file.
The file imports perfectly when I do it manually but when I set up a
Macro and run it I get "Field 'NoName' doesn't exist in the
destination table 'ImportData.'

There is no such field in the table I am trying to import from.

Also, is there any way to use wildcards when specifying the FileName?

Thank you for any help,

Ben

Try it without a macro then. Use the
Docmd.TransferText method
instead

[Benji]

On Thu, 27 May 2004 17:09:30 GMT, Salad <oi*@vinegar.com> wrote:

Benji wrote:

I am trying to automate the import of a text delimited file.
The file imports perfectly when I do it manually but when I set up a
Macro and run it I get "Field 'NoName' doesn't exist in the
destination table 'ImportData.'

There is no such field in the table I am trying to import from.

Also, is there any way to use wildcards when specifying the FileName?

Thank you for any help,

Ben

Try it without a macro then. Use the
Docmd.TransferText method
instead

Thanks for the reply. I'm not sure which question you were answering.
I did use code as you suggested and it works fine if the file name to
import is the name in the code. I still can't figure out how to use
wildcards. The first part of the filename is always the same, but the
end is always different. Would you know if it is possible to use
wildcards in code to import a file?

Thanks again