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

oldmillsaddleryAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Patrick MatthewsCommented:
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
0
NorushCommented:
You need to do this once or more often ?
0
Rey Obrero (Capricorn1)Commented:
csv are also text file. use

Action
TransferText

transfer type  export delimited

table Name    frooglefeed
file name       U:\judi\frooglefeedReadyUpload.csv
has field names  Yes
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

oldmillsaddleryAuthor Commented:
Hi Capricorn1,
I am getting a message can't update Database or Object is read only . Any Ideas
0
Rey Obrero (Capricorn1)Commented:
check the macro that you created.
0
Jeffrey CoachmanMIS LiasonCommented:
oldmillsaddlery,

Take a close look at your spelling of your output file name.
You will get this error when you give the filename a non-standard extension for a text file.

So:
    U:\judi\frooglefeedReadyUpload.cvs
    U:\judi\frooglefeedReadyUpload.xtx
Will NOT work, but:...
    U:\judi\frooglefeedReadyUpload.csv
    U:\judi\frooglefeedReadyUpload.txt
WILL work.
;-)

JeffCoachman
0
aikimarkCommented:
Use DoCmd.TransferText

Note: TransferText can also be invoked from a macro as an action
0
Rey Obrero (Capricorn1)Commented:
B ???  
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.