Solved

how can i Export ms access table to CSV file

Posted on 2008-10-25
8
393 Views
Last Modified: 2012-05-05
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

0
Comment
Question by:oldmillsaddlery
8 Comments
 
LVL 92

Expert Comment

by:Patrick Matthews
Comment Utility
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
 
LVL 7

Expert Comment

by:Norush
Comment Utility
You need to do this once or more often ?
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 65 total points
Comment Utility
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
 

Author Comment

by:oldmillsaddlery
Comment Utility
Hi Capricorn1,
I am getting a message can't update Database or Object is read only . Any Ideas
0
What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
check the macro that you created.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 30 total points
Comment Utility
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
 
LVL 45

Assisted Solution

by:aikimark
aikimark earned 30 total points
Comment Utility
Use DoCmd.TransferText

Note: TransferText can also be invoked from a macro as an action
0
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
B ???  
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now