transfertext won't export to file extension .DAT

[cmmsi]

Ok folks, in your spare time, perhaps you will give this a look. In using Access 2003, and running a macro to transfer text from a query, it appears that the file extension needs to be .TXT, and perhaps there are a few others.

I use different extensions depending on where the data is going, and what it will do, so I am trying to export in this case to .DAT and I get an error indicating

'Cannot update. Database or object is read only'.

I have checked several places, but to no avail. For reference, here are a couple:

http://support.microsoft.com/kb/295200/EN-US/

http://support.microsoft.com/kb/304146/en-us

To say I am completely at a loss, is an understatement.

Any ideas?

 

[longhair]

cmmsi,
how about exporting your data to .txt then using vba to change the file extension?
regards,
longhair

 

[PHV]

Tip (VBA code):
Name "filename.txt" As "filename.dat"

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[RobertT687]

This can be fixed by a simple registry hack to
HKEy_Local_Machine\Software\Microsoft\Jet\4.0\Engines\Text\Extensions and to
HKEy_Local_Machine\Software\Microsoft\Jet\4.0\Engines\Text\DisabledExtensions

Edit each key and add 'dat' to the list of values already present.

The value 4.0 may be different on your machine depending on which veriosn of Access/Jet is installed.

 

[cmmsi]

Most excellent, and thank you all. I utilized the registery hack, rebooted, and all is well.

Thanks again.