Problem with Exporting non-traditional extension

B

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
 
D

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
 
B

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,
Click to expand...

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

Burt
 
Top