Schema.ini ignored - Export Text

  • Thread starter Thread starter Nicodemus
  • Start date Start date
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…
 
Nicodemus said:
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.

Although I have not proved it, I came to the opinion that Access was not
even looking at the Schema file.
This morning I am going to try and make it work by editing the system
tables.
 
Back
Top