Transfertext Macro to export a table

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
 
Joined
Dec 8, 2005
Messages
2
Reaction score
0
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
 
Joined
Dec 8, 2005
Messages
2
Reaction score
0
It turns out you have to designate the output file as a .csv file... the macro now runs with no problems.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top