Hi y'all can any one help me sort out this problem? I'm trying to lift data from a dbase file into an sql server table . i use and odbc data provider for dotnet to do the connection. I'm trying to do a select into from the dbase file in to the sql server table using the openrowset(). but it thriws me this exception:
"System.Data.Odbc.OdbcException: ERROR [42000]
[Microsoft][ODBC SQL Server Driver][SQL Server]OLE DB provider
'Microsoft.Jet.OLEDB.4.0' reported an error. ERROR [01000]
[Microsoft][ODBC SQL Server Driver][SQL Server][OLE/DB provider returned message:
Could not find installable ISAM.]"

this is wut the query looks like
"Select * INTO <TBBLE>
   FROM OPENROWSET('Microsoft.Jet.OLEBD.4.0', 'Driver=dBase IV;
      SourceDB=C:\path;
      SourceType=DBF',
      '<SOURCE TABLE>')"
please help me out on this

Is the file actually from dbase IV file format or other format like foxpro, Visual Fox Pro
If you want to check the version of the VFP ODBC driver or to see if it is installed go into your ODBC Data Source Administrator [under Control Panel,Administrative Tools,Data Sources (ODBC)] and go to the Drivers tab and scroll down the list of installed drivers, see "Microsoft Visual FoxPro Driver" and to the right of it is the version number that is installed.

If your VFP ODBC driver is current it should show a version equal to or greater than 6.01. If it does not you may consider upgrading the the latest mdac version.


Jaime E. Maccou