Importing .DBF file to sql server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

Importing .DBF file to sql server

Author

Topic

anjali66
Starting Member

23 Posts

Posted - 2011-01-05 : 17:55:28

hello Everyone,

I am trying to import a .dbf file to sql server 2008 R2. After googling it, I found this article that says to run

select * from OPENROWSET

('MICROSOFT.JET.OLEDB.4.0','dBase IV;HDR=NO;IMEX=2;

DATABASE=C:\mcc.DBF','select * from MCc.DBF')

I am getting an error "The OLE DB provider "MICROSOFT.JET.OLEDB.4.0" has not been registered."

I didn't do anyting on "Data Sources(ODBC) in control panel". I have a 32 bit version operating system and I am running it on windows XP.

Any help will be appreciated.

Thanks.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-05 : 17:56:53

Reinstall the ODBC drive as it sounds like it's not right.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2011-01-06 : 12:53:35

Your connection string looks wrong to me. You pass the path to the data folder, not the actual file.

Data Source=pathToDataFolder;Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE IV;

Example:

Data Source=C:\DBaseFile\;Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=dBASE IV;

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources