transfertext method

[gruffalo]

I am attempting to transfer a text file into Access 2000.
However the extension for this file is not the standard
extension for a text file. It's *.mts which comes from an
external provider. I can get the transfertext to work fine
if I convert the mts file to .txt in Excel first but I
would like to be able to skip this step.

When I attempt to do the transfertext for the *.mts file i
get the following message;

"3027 - Cannot Update. Database or Object is read only"

Is there anyway around this?

 

[solex]

How about the FileCopy statement to copy the file from *.mts to *.txt?

 

[Marshall Barton]

I am attempting to transfer a text file into Access 2000.
However the extension for this file is not the standard
extension for a text file. It's *.mts which comes from an
external provider. I can get the transfertext to work fine
if I convert the mts file to .txt in Excel first but I
would like to be able to skip this step.

When I attempt to do the transfertext for the *.mts file i
get the following message;

"3027 - Cannot Update. Database or Object is read only"

Is there anyway around this?

If you can't find another way, you could use the Name
statement to rename the file, then do the transfertext and
name the file back to what it was.

 

[John Nurick]

Hi Gruff,

One of these should suit:

This http://support.microsoft.com/default.aspx?scid=kb;en-us;304206
shows how to change the extensions that Access will accept. The neatest
method is the last, editing the registry (provided you're careful<g>).

This http://support.microsoft.com/default.aspx?scid=kb;EN-GB;306144
includes code that automatically makes a copy of the textfile with a
..txt extension and imports that.