Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Export csv file format - Access 2002

Posted on 2008-10-08
16
Medium Priority
?
239 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

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

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
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 …
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Suggested Courses

971 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