transfertext method

  • Thread starter Thread starter gruffalo
  • Start date Start date
G

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?
 
gruffalo said:
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?
Click to expand...


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.
 
Back
Top