Transfertext Macro to export a table

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

I have a table with approx 125,000 records that I try to
export as a txt file. I get the message "can't update,
database or object is read only". When I use the
file/export commands manually it exports fine. Any Ideas?
TIA -- tony
 
I am trying to do the same thing, and I get the same error. This is the first time I have used a macro in access.....


I am using transfertext on a query.

here are the action arguements:

export delimited
""
Household Income
C:\Projects\midas\macro_output\test
yes
""
""

I can export to a text file manually so I don't really think it is a permissions problem, but I don't know how to fix this.

Thanks

J
 
It turns out you have to designate the output file as a .csv file... the macro now runs with no problems.
 
Back
Top