when I query DBF database, fields are empty or null

we are supporting a website that uses DBF files extracted from a real
estate listing windows application. the website has used a DSN using
Microsoft's DBase Driver with ADO connections, and worked for some
time.

recently, they upgraded to a new version of the software, and something
has changed about the DBF files so that most of the fields in the table
turn out null when reading them through the Windows drivers.

when I open the files using a DBFViewer, I can see the values of the
fields just fine. but when I try to access them through ADO, or import
them to a SQL Server table, all the fields except the first one are
null.

has anyone seen something like this? do you know what could be going
on?

thanks!

dan

.

Relevant Pages

  • Re: accessing dbf files
    ... cn.Open "Driver={Microsoft dBASE Driver ... Regards, ... Uwa Agbonile ... > I'm trying to use ADO to read data from some dbf files in order to import ...
    (microsoft.public.data.ado)
  • Re: Halcyon6
    ... > Anyone knows Halcyon6 components to manage DBF files? ... Author's website: http://www.grifsolu.com ... Ray Marron ...
    (borland.public.delphi.thirdpartytools.general)