By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,145 Members | 1,485 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,145 IT Pros & Developers. It's quick & easy.

Problem with Transfer Test

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

Nov 13 '05 #2

P: n/a
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

Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.