Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

schema.ini ignored doing TransferText

9 views
Skip to first unread message

makyland

unread,
Dec 11, 2009, 6:54:01 AM12/11/09
to
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.

0 new messages