Problem with Exporting non-traditional extension

[Burt Rosner]

To Whoever Can Advise,

I am trying to export a text file with an extension
of .old. When I use "DoCmd.TransferText acExportDelim" I
get a "read Only" error message. Is there a way of
creating a text file without using the ".txt" extension.

Please advise.

Thanks,

Burt

 

[Douglas J. Steele]

Check the following KB articles. While they talk about importing, the same
should hold for exporting:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407
ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

FWIW, it's probably simplest simply to export to a file with an extension of
..TXT, and rename the file using the VBA Name statement:

Name oldpathname As newpathname

 

[Burt Rosner]

-----Original Message-----
Check the following KB articles. While they talk about importing, the same
should hold for exporting:

ACC2000: "Can't Update. Database or Object Is Read-only" Error Message When
You Import Files
http://support.microsoft.com/?id=245407
ACC2000: How to Import a Text File That Has an Extension That Access Does
Not Recognize
http://support.microsoft.com/?id=306144

FWIW, it's probably simplest simply to export to a file with an extension of
..TXT, and rename the file using the VBA Name statement:

Name oldpathname As newpathname

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)






.
Doug,

Thanks, I'm going to look at it now.

Burt