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