Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how can i Export ms access table to CSV file

Posted on 2008-10-25
8
Medium Priority
?
403 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 93

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 195 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

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 90 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 46

Assisted Solution

by:aikimark
aikimark earned 90 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

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

580 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