Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

how can i Export ms access table to CSV file

Posted on 2008-10-25
8
Medium Priority
?
399 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
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)

 

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

719 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