T
TL
file I am having a problem exporting a table from SQL to a text using a
custom delimiter. When using a default of csv everything works fine. Below
please see some of the code I am using and below that is the schema file. I
am a little confused because I never want the file name to be the same so I
am not sure what to put in the first line.
Extension = ".txt"
'Identity = Format(Now(), "ddmmyyyy")
Identity = Format(Now(), "mmddyyyyhhnnss")
Identity1 = Identity & Extension
Location = "C:\Program Files\Files\Prr110_results_" & Identity1
DoCmd.Hourglass (False)
DoCmd.TransferText acExportDelim, "Schema.ini", _
"dbo." & Tablename, Location, True
Schema
ColNameHeader=True
CharacterSet=1252
Format=Delimited(~)
Col1=name Char Width 50
Col2="name 2" Char Width 50
Col3="name 3" Char Width 50
custom delimiter. When using a default of csv everything works fine. Below
please see some of the code I am using and below that is the schema file. I
am a little confused because I never want the file name to be the same so I
am not sure what to put in the first line.
Extension = ".txt"
'Identity = Format(Now(), "ddmmyyyy")
Identity = Format(Now(), "mmddyyyyhhnnss")
Identity1 = Identity & Extension
Location = "C:\Program Files\Files\Prr110_results_" & Identity1
DoCmd.Hourglass (False)
DoCmd.TransferText acExportDelim, "Schema.ini", _
"dbo." & Tablename, Location, True
Schema
ColNameHeader=True
CharacterSet=1252
Format=Delimited(~)
Col1=name Char Width 50
Col2="name 2" Char Width 50
Col3="name 3" Char Width 50