export to CSV file

  • Thread starter Thread starter Tanya via AccessMonster.com
  • Start date Start date
T

Tanya via AccessMonster.com

Hi,

i am trying to get a temp table to export directly to a csv file however i am
having a few problems with "

this is what i have thus far:

DoCmd.TransferText transfertype:=acExportDelim, _
TableName:="SOIC_New", _
Filename:="V:\SOIC\XLS_CSV\" & Me.State & "\CSV\Install\" &
"SSCI&M" & _
Format(Me.EndingDate, "ddmmyy") & "Summary" & ".csv", _
HasFieldNames:=False

now when i open the csv in say notepad it gives me this
"SSCCNVLJ",951099,"270506",""

how do i get rid of the " " so it looks like this
SSCCNVLJ,951099,270506

any help or push in the right direction is greatly appreciated

Tanya
 
Hi,

i figured this one out by setting up and using a specification name.

DoCmd.TransferText transfertype:=acExportDelim, _
SpecificationName:="SOIC_CSV", _
TableName:="SOIC_New", _
Filename:="V:\SOIC\XLS_CSV\" & Me.State & "\CSV\Install\" &
"SSCI&M" & _
Format(Me.EndingDate, "ddmmyy") & "Summary" & ".csv", _
HasFieldNames:=False

woohoo.....
 
Back
Top