N
Nicodemus
Hello all,
I'm desperately trying to export a table to a text file using a schema.ini
file but could not get it working the way I want : no double quotes included.
The reason why I use a Schema file rather than an Export Specification is
that there will be more tables created for which I don’t know the structure.
The Schema file is created automatically through
http://support.microsoft.com/kb/155512, and is saved in the same destination
folder as the exported files.
I work with XP pro and Access 2003 SP3.
I'm googling for 3 days now and still can not find anything to explain why
it fails.
Can someone tell me what I’m doing wrong ?
Thank you in advance for any support.
Nicodemus
My table 'customers' contains :
Name | Gender
Sam | M
Sue | F
After exporting to text file :
"Sam",â€Mâ€
"Sue",â€Fâ€
Wished text format :
Sam,M
Sue,F
my VBA code :
DoCmd.TransferText acExportDelim, , "customers", "C:\temp\test.txt", False
my Schema.ini file (saved in "C:\temp\â€) :
[test.txt]
CharacterSet = ANSI
textDelimiter=none
ColNameHeader = False
Format = CVSDelimited
Col1="Name" char Width 5
Col2="Gender" char Width 1
PS: I’ve tried various textdelimiter declarations, such =none, =â€â€, =’’,
even tried =# but none of them got the double quotes removed…
Also added MaxScanRows=0, no luck…
I'm desperately trying to export a table to a text file using a schema.ini
file but could not get it working the way I want : no double quotes included.
The reason why I use a Schema file rather than an Export Specification is
that there will be more tables created for which I don’t know the structure.
The Schema file is created automatically through
http://support.microsoft.com/kb/155512, and is saved in the same destination
folder as the exported files.
I work with XP pro and Access 2003 SP3.
I'm googling for 3 days now and still can not find anything to explain why
it fails.
Can someone tell me what I’m doing wrong ?
Thank you in advance for any support.
Nicodemus
My table 'customers' contains :
Name | Gender
Sam | M
Sue | F
After exporting to text file :
"Sam",â€Mâ€
"Sue",â€Fâ€
Wished text format :
Sam,M
Sue,F
my VBA code :
DoCmd.TransferText acExportDelim, , "customers", "C:\temp\test.txt", False
my Schema.ini file (saved in "C:\temp\â€) :
[test.txt]
CharacterSet = ANSI
textDelimiter=none
ColNameHeader = False
Format = CVSDelimited
Col1="Name" char Width 5
Col2="Gender" char Width 1
PS: I’ve tried various textdelimiter declarations, such =none, =â€â€, =’’,
even tried =# but none of them got the double quotes removed…
Also added MaxScanRows=0, no luck…