Acess 2003 Text File Export

[hbarnett]

I am in process of converting Access 97 databases to Access 2003. Some
of the Access 97 databases export data to a text file with a non
standard file extension, such as "ext" or "NAL". When I try to
run the export in the converted Access 2003 database, I get the error
"Cannot update: Database or object is read-only."

It seems that the real problem is that I can only export a text file if
I use either "txt", "csv", "tab", or "asc" as the file
extension. Is there a way around that requirement?

I can write an application to run after the export to rename the file
with the correct extension, but it is frustrating to not be able to
name the export file what I want it named in the Access export.

Hugh Barnett

[Tom van Stiphout]

On 7 Nov 2006 09:59:33 -0800, "hbarnett" <hb******@natspin.comwrote:

A way around that? How about the Name statement? Didn't have to do
that before? So you adjust.

-Tom.

>I am in process of converting Access 97 databases to Access 2003. Some
of the Access 97 databases export data to a text file with a non
standard file extension, such as "ext" or "NAL". When I try to
run the export in the converted Access 2003 database, I get the error
"Cannot update: Database or object is read-only."

It seems that the real problem is that I can only export a text file if
I use either "txt", "csv", "tab", or "asc" as the file
extension. Is there a way around that requirement?

I can write an application to run after the export to rename the file
with the correct extension, but it is frustrating to not be able to
name the export file what I want it named in the Access export.

Hugh Barnett

[hbarnett]

Tom van Stiphout wrote:

On 7 Nov 2006 09:59:33 -0800, "hbarnett" <hb******@natspin.comwrote:

A way around that? How about the Name statement? Didn't have to do
that before? So you adjust.

-Tom.

I'm not familiar with the name statement.

In Access 97, I could export a text file named "aaaaaaaa.bbb" using
the TransferText command. In Access 2003 it will not allow this since
the extension is not "txt', "csv", "tab", or "asc". I was
hoping that there was a way to allow me to export the file
"aaaaaaaa.bbb" in Access 2003.

Hugh Barnett

[pietlinden]

hbarnett wrote:

Tom van Stiphout wrote:

On 7 Nov 2006 09:59:33 -0800, "hbarnett" <hb******@natspin.comwrote:

A way around that? How about the Name statement? Didn't have to do
that before? So you adjust.

-Tom.

I'm not familiar with the name statement.

In Access 97, I could export a text file named "aaaaaaaa.bbb" using
the TransferText command. In Access 2003 it will not allow this since
the extension is not "txt', "csv", "tab", or "asc". I was
hoping that there was a way to allow me to export the file
"aaaaaaaa.bbb" in Access 2003.

Hugh Barnett

export the file using TransferText. If you have the name of the file
in a variable, you can use Name to rename the file to something else,
like "aaaaaaa.bbb", where you have full control over the filename and
extension.