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 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
 
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 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
Click to expand...

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
 
Hi Rod, sorry but I can't retrieve the post you refer to. Can you give its
subject and date ?
Nico


Rod said:
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 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
Click to expand...

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



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

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



Rod said:
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 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
Click to expand...

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



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

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

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



Rod 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 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



.
Click to expand...
Click to expand...


.
Click to expand...
 
Nicodemus said:
ok, found. Well, I'll give a try and see what comes out.
I'll keep you posted
Click to expand...


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.


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

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



.
Click to expand...


.
Click to expand...
Click to expand...
 
Back
Top