Unicode and CSV files

From: Scott McBurney (ScottMcBurney_at_discussions.microsoft.com)
Date: 02/25/05 

Date: Fri, 25 Feb 2005 07:21:02 -0800

I want to use the MS Text Driver to read and write CSV files that contain
unicode data from VB6. However, I haven't been able to get the driver to
read the files properly (haven't even tried writing yet). The driver appears
to be reading the BOM of the file and treating it as a field name.

Does anyone have any idea how to configure the text driver to understand
unicode CSV files?

If you can't use the text driver, then what driver can you use? Microsoft
Word is able to successfully read unicode csv files to perform a mail merge,
so it would be great if there were some documentation explaining how it does
it. 

-- 
Scott McBurney
Software Developer
Interface Software, Inc.

Relevant Pages

  • 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)
  • ADO and MS Text Driver and Unicode
    ... We have CSV files that are in UTF8 or UTF16 format, so they have a BOM at ... How would you get the MS Text Driver to read these properly? ...
    (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: Unicode and Microsoft Text Driver
    ... majority isn't. ... There is no guarantee that your questions will be answered. ... I haven't been able to get the driver to ... >> unicode CSV files? ...
    (microsoft.public.data.ado)