ADO and MS Text Driver and Unicode

From: Scott McBurney (ScottMcBurney_at_discussions.microsoft.com)
Date: 03/16/05 

Date: Wed, 16 Mar 2005 08:13:02 -0800

Ok, here is the dilema....

We have CSV files that are in UTF8 or UTF16 format, so they have a BOM at
the beginning of them.

How would you get the MS Text Driver to read these properly? There is
almost no doc on the text driver.

I know it can be done, because Word can perform a mail merge using the
encoded CSV files, and it even prompts for confirmation of the encoding. And
it is using the MS Text driver.

Anyone know how to read these?

Using the text driver normally, it chokes on the BOM and cannot read the
first line of the CSV file that contains the field names. I know there is
some way to get this to work, but its just not documented anywhere. 

-- 
Scott McBurney
Software Developer
LexisNexis Interface Software, Inc.

Relevant Pages

  • Unicode and CSV files
    ... I want to use the MS Text Driver to read and write CSV files that contain ... unicode data from VB6. ... Word is able to successfully read unicode csv files to perform a mail merge, ...
    (microsoft.public.data.ado)
  • RE: Unicode and Microsoft Text Driver
    ... I haven't been able to get the driver to ... > I know it can be done, since MS Word can read the Unicode CSV files without ... > Software Developer ...
    (microsoft.public.data.ado)
  • Unicode and Microsoft Text Driver
    ... I want to use the MS Text Driver to read and write CSV files that contain ... unicode data from VB6. ... I know it can be done, since MS Word can read the Unicode CSV files without ...
    (microsoft.public.data.ado)
  • Re: Unicode and CSV files
    ... I believe ODBC driver for Text might not support Unicode. ... >I want to use the MS Text Driver to read and write CSV files that contain ... > Software Developer ...
    (microsoft.public.data.ado)
  • Re: New sticks for 2006
    ... Tom K wrote: ... might be your new driver for you. ... I'm quite happy with the BoM and I still need to keep some ... -Nigel Powers ...
    (rec.sport.golf)