Solved

how can i Export ms access table to CSV file

Posted on 2008-10-25
8
395 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
ID: 22803167
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
ID: 22803209
You need to do this once or more often ?
0
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 65 total points
ID: 22803224
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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 

Author Comment

by:oldmillsaddlery
ID: 22803354
Hi Capricorn1,
I am getting a message can't update Database or Object is read only . Any Ideas
0
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22803430
check the macro that you created.
0
 
LVL 74

Assisted Solution

by:Jeffrey Coachman
Jeffrey Coachman earned 30 total points
ID: 22804147
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
ID: 22804182
Use DoCmd.TransferText

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

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 22804539
B ???  
0

Featured Post

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Most if not all databases provide tools to filter data; even simple mail-merge programs might offer basic filtering capabilities. This is so important that, although Access has many built-in features to help the user in this task, developers often n…
In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

815 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

10 Experts available now in Live!

Get 1:1 Help Now