TransferText

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zamdrist - 27 Feb 2007 15:22 GMT

Getting an error message trying to run the TransferText command of the
DoCmd object.

"...Jet Database Engine could not find database object
'export.txt'..."

DoCmd.TransferText acImportFixed, "cmdExport", "qryOperation", "\
\mediaagent\dmsimport\export.txt"

Well I don't quite understand why I am getting this error message
considering that export.txt is the destination output. I can use
TransferSpreadSheet command just fine without errors, sans the export
spec.

I verified the export spec does exist in the same database, the path
is valid and it doesn't appear to matter whether I use UNC or or a
mapped drive letter either.

Thoughts?

Thanks

Reply to this Message

Ralph - 27 Feb 2007 15:43 GMT

You say you are trying to Export the file, but you are using acImportFixed??

> Getting an error message trying to run the TransferText command of the
> DoCmd object.
[quoted text clipped - 17 lines]
>
> Thanks

Reply to this Message

Zamdrist - 27 Feb 2007 15:50 GMT

> You say you are trying to Export the file, but you are using acImportFixed??

A good point, lol...I actually copy and pasted that...I *am* exporting
and I *am* using acExportFixed.

DoCmd.TransferText acExportFixed, "cmdExport", "qryOperation", "\
\mediaagent\dmsimport\export.txt", vbNo

A mistake on my part and only muddies the water, sorry about that. I
am using the right argument in my code and get the error message
regardless.

Reply to this Message

Dirk Goldgar - 28 Feb 2007 04:46 GMT

>> You say you are trying to Export the file, but you are using
>> acImportFixed??
[quoted text clipped - 8 lines]
> am using the right argument in my code and get the error message
> regardless.

It's not obvious to me yet exactly what's wrong, but I can tell you that
you should not be using the defined constant vbNo in that statement;
you probably should be using False instead:

DoCmd.TransferText _
acExportFixed, _
"cmdExport", _
"qryOperation", _
"\\mediaagent\dmsimport\export.txt", _
False

So "cmdExport" is the name of an import/export specification that is
defined in this database? And the folder "\\mediaagent\dmsimport"
exists, on the computer where this code is running?

What is the exact error message?

Signature

Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)

Reply to this Message