TransferText 1

[LarryDeLaruelle]

I am trying to set up a TransferText and receive an error message:

Run-time error '3027':
Cannot update. Database or object is read only.

Here is my code:

DoCmd.TransferText acExportDelim, , "tblSvcTypeTest", "H:\Archive\SvcTypeTest", -1

I have full admin rights to the database

I'm using Access 2K with service pack 3 installed

I ran the manual export on this table and it worked fine.

Any idea why its choking on me?

Larry De Laruelle

 

[Remou]

You will need a suitable extension, .txt for example, unless you wish to edit the registry.

 

[LarryDeLaruelle]

Remou:

Many thanks.

That was certainly a Homer Simpson Doh! moment.

I had assumed (always a dangerous thing to do) that Access would add an appropriate extension when it created the file.

Added a .txt extension to the file name and it worked like magic.

Larry De Laruelle

 

[LarryDeLaruelle]

Remou (or anyone):

Thanks again for the help. New question.

We are exporting this information in a CVS format for upload to our payroll system. All of the text fields are being exported within quotation marks which the payroll system does not like.

Is there a way to format the export/output to eliminate the quotation marks?

Thanks.

Larry De Laruelle

 

[Remou]

You can use a Specification. Step through the export manually (File->Export) and choose the Advanced button to save the Specification.

 

[LarryDeLaruelle]

Remou:

You're a life saver.

Will it always save the exported file as an Excel associated file? When I look at the file in Explorer it has the Excel icon and if I double click to open it opens in a work book.

If I use open with and use note pad its a regular text file; haven't tested with the payroll upload but this should work.

Thanks again. If you are ever in northern Indiana, let me know, I'll buy you the beverage of your choice.

Larry De Laruelle

 

[Remou]

If the extension is .csv, it will be associated with Excel, unless you wish to change file associations.