Schema.ini ignored - Export Text

[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 Schema.ini file is created automatically
(http://support.microsoft.com/kb/155512) and is saved in the same destination
folder.
The reason for using a schema file rather than an Export Specification is
that there will be more tables in the future for which I don't know the
structure.
I'm googling for 2 days now and still can not find anything to explain why
it fails.
I work with XP professional and Access 2003 SP3

Can someone tell me what I’m doing wrong ?
Thank you for your help.
Nico

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

 

[Rod]

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 Schema.ini file is created automatically
(http://support.microsoft.com/kb/155512) and is saved in the same
destination
folder.
The reason for using a schema file rather than an Export Specification is
that there will be more tables in the future for which I don't know the
structure.
I'm googling for 2 days now and still can not find anything to explain why
it fails.
I work with XP professional and Access 2003 SP3

Can someone tell me what I'm doing wrong ?
Thank you for your help.
Nico

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

I had the same problem sometime ago. I am currently trying to do the same
again. See my post a couple below yours on Link Specifications using a
different approach.
Please post if you solve it as I am interested.

thanks

Rod

 

[Nicodemus]

Hi Rod, sorry but I can't retrieve the post you refer to. Can you give its
subject and date ?
Nico

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 Schema.ini file is created automatically
(http://support.microsoft.com/kb/155512) and is saved in the same
destination
folder.
The reason for using a schema file rather than an Export Specification is
that there will be more tables in the future for which I don't know the
structure.
I'm googling for 2 days now and still can not find anything to explain why
it fails.
I work with XP professional and Access 2003 SP3

Can someone tell me what I'm doing wrong ?
Thank you for your help.
Nico

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

I had the same problem sometime ago. I am currently trying to do the same
again. See my post a couple below yours on Link Specifications using a
different approach.
Please post if you solve it as I am interested.

thanks

Rod



.

 

[Rod]

Hi Rod, sorry but I can't retrieve the post you refer to. Can you give its
subject and date ?

Editing Link Specifications and system tables
24/02/2010 17:24
If you can't find it just put the title as is into google

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 Schema.ini file is created automatically
(http://support.microsoft.com/kb/155512) and is saved in the same
destination
folder.
The reason for using a schema file rather than an Export Specification
is
that there will be more tables in the future for which I don't know the
structure.
I'm googling for 2 days now and still can not find anything to explain
why
it fails.
I work with XP professional and Access 2003 SP3

Can someone tell me what I'm doing wrong ?
Thank you for your help.
Nico

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

I had the same problem sometime ago. I am currently trying to do the same
again. See my post a couple below yours on Link Specifications using a
different approach.
Please post if you solve it as I am interested.

thanks

Rod



.

 

[Nicodemus]

ok, found. Well, I'll give a try and see what comes out.
I'll keep you posted

Hi Rod, sorry but I can't retrieve the post you refer to. Can you give its
subject and date ?

Editing Link Specifications and system tables
24/02/2010 17:24
If you can't find it just put the title as is into google

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 Schema.ini file is created automatically
(http://support.microsoft.com/kb/155512) and is saved in the same
destination
folder.
The reason for using a schema file rather than an Export Specification
is
that there will be more tables in the future for which I don't know the
structure.
I'm googling for 2 days now and still can not find anything to explain
why
it fails.
I work with XP professional and Access 2003 SP3

Can someone tell me what I'm doing wrong ?
Thank you for your help.
Nico

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



I had the same problem sometime ago. I am currently trying to do the same
again. See my post a couple below yours on Link Specifications using a
different approach.
Please post if you solve it as I am interested.

thanks

Rod



.

.

 

[Rod]

ok, found. Well, I'll give a try and see what comes out.
I'll keep you posted

I've just made the way I outline in those posts work. I modify the tables
using code on the fly and Access seems happy.

Hi Rod, sorry but I can't retrieve the post you refer to. Can you give
its
subject and date ?

Editing Link Specifications and system tables
24/02/2010 17:24
If you can't find it just put the title as is into google

:


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 Schema.ini file is created automatically
(http://support.microsoft.com/kb/155512) and is saved in the same
destination
folder.
The reason for using a schema file rather than an Export
Specification
is
that there will be more tables in the future for which I don't know
the
structure.
I'm googling for 2 days now and still can not find anything to
explain
why
it fails.
I work with XP professional and Access 2003 SP3

Can someone tell me what I'm doing wrong ?
Thank you for your help.
Nico

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



I had the same problem sometime ago. I am currently trying to do the
same
again. See my post a couple below yours on Link Specifications using a
different approach.
Please post if you solve it as I am interested.

thanks

Rod



.

.