Link to home
Start Free TrialLog in
Avatar of oldmillsaddlery
oldmillsaddleryFlag for United Kingdom of Great Britain and Northern Ireland

asked on

how can i Export ms access table to CSV file

I need to export a table from ms access to a csv file in a location on my computer

Table is called frooglefeed
location is U:\judi
csv file is called frooglefeedReadyUpload

I tried using a ms access macro but can't see the opyion for csv file

Avatar of Patrick Matthews
Patrick Matthews
Flag of United States of America image

Hello oldmillsaddlery,

A CSV file is simply a comma delimited text file.  If you must have a CSV extension for some reason, just
change the txt to csv after export.

Regards,

Patrick
You need to do this once or more often ?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of oldmillsaddlery

ASKER

Hi Capricorn1,
I am getting a message can't update Database or Object is read only . Any Ideas
check the macro that you created.
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial