none
.dbf file import (duplicate Field Names) RRS feed

  • Question

  • I am importing a file creating by an application which exports the file into .dbf format.  Very unfortunately, this .dbf file can have fields with IDENTICAL column_names.  Utilizing ActiveX, I create an ado connection to the .dbf file using a visual foxpro drver.  However, and not unexpectantly, I can not do the 'select *' from the file if there are duplicate names.

    Can anyone make recommendations here that might help?

    Oh, this is SQL200 in case that impacts what you might advise!!!!

    Monday, March 27, 2006 2:58 PM

All replies

  • Anyone out there from MSFT want to make some suggestions?
    Thursday, March 30, 2006 3:42 PM
  • Hi Ellen,

    I find it surprising that the DBF file can have duplicate field names. What application created it? Is it a FoxPro DBF or a DbaseIV or Paradox DBF?

    I assume you are able to read the table structure with something other than SQL Server, is that correct?

    Are you using ODBC or OLE DB? The latest FoxPro and Visual FoxPro OLE DB data provider is downloadable from msdn.microsoft.com/vfoxpro/downloads/updates .

    Friday, March 31, 2006 6:41 PM