M
makyland
Hi!
I would like to import multiple files that are comma separated, where
decimal separator is point.
As the utility will be used in different computers and some of them might
have regional settings different than US standard, I would like to use
schema.ini to indicate format=CSVDelimited and DecimalSymbol=.
However, I create a schema.ini with this content:
[auxiliar.csv]
ColNameHeader=true
Format=CSVDelimited
DecimalSymbol=.
I saved schema.ini in the same location as auxiliar.csv, but Access 2007 (or
2003, I tested both) is ignoring it.
Reading other posts I also made sure schema.ini is saved as ANSI.
Am I missing anything?
A sample of the contents of auxiliar.csv:
FIELD1,FIELD2,FIELD3,FIELD4
4.36000013,100,7,4.00070000
0.20000000,100,7,8.01200000
And I'm testing it like:
DoCmd.TransferText acImportDelim, , "auxiliar", "C:\auxiliar.csv", True
In fact I've done many other types of tests, including all possible
parameters of schema.ini and specification of each column, but it is always
ignored...
I even removed Access 2007 Developer Extensions in case it could be
affecting anyhow...
Thanks in advance for your help.
I would like to import multiple files that are comma separated, where
decimal separator is point.
As the utility will be used in different computers and some of them might
have regional settings different than US standard, I would like to use
schema.ini to indicate format=CSVDelimited and DecimalSymbol=.
However, I create a schema.ini with this content:
[auxiliar.csv]
ColNameHeader=true
Format=CSVDelimited
DecimalSymbol=.
I saved schema.ini in the same location as auxiliar.csv, but Access 2007 (or
2003, I tested both) is ignoring it.
Reading other posts I also made sure schema.ini is saved as ANSI.
Am I missing anything?
A sample of the contents of auxiliar.csv:
FIELD1,FIELD2,FIELD3,FIELD4
4.36000013,100,7,4.00070000
0.20000000,100,7,8.01200000
And I'm testing it like:
DoCmd.TransferText acImportDelim, , "auxiliar", "C:\auxiliar.csv", True
In fact I've done many other types of tests, including all possible
parameters of schema.ini and specification of each column, but it is always
ignored...
I even removed Access 2007 Developer Extensions in case it could be
affecting anyhow...
Thanks in advance for your help.