DoCmd.TransferText acExportDelimited

[Randy]

In a module I have a do command to transfer a table to a tab seperated text
file. I get the message 'Run-time error 31519 You cannot import this file.'
Do you have any ideas about what I'm doing wrong.

 

[Ken Snell [MVP]]

Show us your code for this step. My first guess is that you have reversed
the placement of some arguments for the TransferText method.

 

[Randy]

Ken, This is the transfer statement. Thanks for your help

stDocName = "tblTPC_Inventory_Hosting_Export"
DoCmd.TransferText acExportDelimited, tblTPC_Inventory_Hosting_Tab, _
stDocName, _

"c:\MyExcelDownload\TPC_Inventory_Hosting_Export.ivh"

 

[Douglas J. Steele]

It's your file extension. It should work fine with .txt

The advice in the following KB articles applies equally to exporting data:
http://support.microsoft.com/?id=245407
http://support.microsoft.com/?id=306144


--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

 

[Ken Snell [MVP]]

And the "export specification" argument has been omitted in the list of
arguments. It is the second argument in the list; it can be left "blank" if
you're not using a spec:

DoCmd.TransferText acExportDelimited, "NameOfSpecification",
tblTPC_Inventory_Hosting_Tab, etc.

or

DoCmd.TransferText acExportDelimited, , tblTPC_Inventory_Hosting_Tab, etc.

 

[Randy]

I got it to work. Thanks for your help

It's your file extension. It should work fine with .txt

The advice in the following KB articles applies equally to exporting data:
http://support.microsoft.com/?id=245407
http://support.microsoft.com/?id=306144

 

[Randy]

It worked. Thanks for your help.

And the "export specification" argument has been omitted in the list of
arguments. It is the second argument in the list; it can be left "blank" if
you're not using a spec:

DoCmd.TransferText acExportDelimited, "NameOfSpecification",
tblTPC_Inventory_Hosting_Tab, etc.

or

DoCmd.TransferText acExportDelimited, , tblTPC_Inventory_Hosting_Tab, etc.