access foxpro data with openrowset

• shakti-236987

  SSC-Addicted

  Points: 438

  More actions

  September 19, 2005 at 2:01 am

  #165962

  Hi all

  I want to convert the foxpro data to SQL with openrowset command.

  I m using the following query to get the data

  select * from openrowset('Microsoft.Jet.OLEDB.4.0',

  'SourceDB=E:\AUTO2004\dbfs;Source Type=DBF;Exclusive=No;BackgroundFetch=Yes;

  Collate=Machine;Null=Yes;Deleted=Yes','select * from model.dbf')

  The following error is returned.

  Server: Msg 7399, Level 16, State 1, Line 1

  OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. 

  [OLE/DB provider returned message: Could not find installable ISAM.]

  OLE DB error trace [OLE/DB Provider 'Microsoft.Jet.OLEDB.4.0' IDBInitialize::Initialize returned 0x80004005:   ].

  Thanks

• DGHagan

  SSC Enthusiast

  Points: 178

  More actions

  September 20, 2005 at 8:58 am

  #591364

  try the visual foxpro oledb driver.

   

  http://www.microsoft.com/downloads/details.aspx?FamilyId=E1A87D8F-2D58-491F-A0FA-95A3289C5FD4&displaylang=en