Solved

Export csv file format - Access 2002

Posted on 2008-10-08
16
223 Views
Last Modified: 2013-11-27
I am trying to export an Access 2002 db table in a csv format

I want it to look like this when exported

"field1","field2","field3","field4"

instead I am getting this if i put a txt extension but I want a csv
"field1        ","field2         ","field3","field4       ","  

and if i put the csv extention i get each field in a separate excel cell across
0
Comment
Question by:Pdeters
  • 8
  • 8
16 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22670328
you have to use

docmd.transfertext acexportdelim, "importspecificationName", "tableName", "c:\myText.csv", true
0
 

Author Comment

by:Pdeters
ID: 22670744
where do i put this
Riht now i have the export in a macro
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22670802
create a new macro, using TransferText and fill out all the necessary info
you will need a new export specification


Action
TransferText


Transfer Type           Export Delimited
Specification Name



0
 

Author Comment

by:Pdeters
ID: 22671028
Ok - but where do I put this?
docmd.transfertext acexportdelim, "importspecificationName", "tableName", "c:\myText.csv", true
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22671070
what do you want a macro or vba solution?

this is vba
docmd.transfertext acexportdelim, "importspecificationName", "tableName", "c:\myText.csv", true
0
 

Author Comment

by:Pdeters
ID: 22671908
either
 just so it turns out corectly

Right now I have the macro
as

Action
TransferText
Transfer Type           Export Delimited
Specification Name

In the Specificiation i have it set up as
Delimited
field Delimiter ,
text qualifieer "

and i get
"field1        ","field2         ","field3","field4       ","  

this is what I want

"field1","field2","field3","field4"
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22671935
your export spec is telling the export to have a fixed width.


can you attach your db?
0
 

Author Comment

by:Pdeters
ID: 22673247
I checked and and redid the specs - still doing -  i belive it is set to delimited
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22673295
run this update query

update tableName set  field1=trim([field1]), field2=trim([field2]),field3=trim([field3]),field4=trim([field4])


then try the export
0
 

Author Comment

by:Pdeters
ID: 22673453
forgot to attached here it is
Reports.mdb
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22673590
this is what i got after running the  macro


Export.csv.txt
0
 

Author Comment

by:Pdeters
ID: 22676985
I don't? could it be 2002 versus 2003 version of access?
Is it common to have csv.txt after then end to make it work?
0
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 22677290
for uploading file to this site >> .csv is not supported
i created the file export.csv directly i just added the .txt to the file name so i can attach the file here.
0
 

Author Comment

by:Pdeters
ID: 22677399
when i open as a csv i get an excel spreadsheet with each in a different cell. I need this
"field1","field2","field3","field4"

is this possbile.
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 22677424
then do not use a .csv as output format,
use .txt
0
 

Author Comment

by:Pdeters
ID: 22679918
I will do that. Sometimes I make things way too difficult.

Thanks
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
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…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …

746 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

9 Experts available now in Live!

Get 1:1 Help Now