Import .dbf files in sql server 2005

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 Integration Services » Import .dbf files in sql server 2005

19 posts, Page 1 of 2

1 2 »»

Import .dbf files in sql server 2005

Rate Topic

Display Mode

Topic Options

Author

Message

bladerunner148

Posted Monday, November 17, 2008 1:55 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 01, 2011 1:41 PM
Points: 102, Visits: 303

Hi there,

I have a .dbf file which i want to import in sql server 2005. When I right click on the database and click Import, I don't know what Data Source I should be using. Is it even possible to import .dbf files?

Thanks

Post #603932

Greg Charles

Posted Monday, November 17, 2008 2:10 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 11:34 AM
Points: 4,007, Visits: 4,857

Choose a data source based on what created the .dbf file (dbase, Foxpro,?). If you can't find one in the list, you might be able to find an ODBC driver for the source or you might have to save the data from the source dbms to a flat file that you can import to SQL Server.

Greg

Post #603942

bladerunner148

Posted Monday, November 17, 2008 2:32 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, November 01, 2011 1:41 PM
Points: 102, Visits: 303

I didn't get it when you said i can change the dbf to a flat file. Could you please specify what do you mean when you said change that to a flat file? What extension will that be?
Thanks!

Post #603959

Phil Parkin

Posted Monday, November 17, 2008 3:00 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 9:39 AM
Points: 4,247, Visits: 9,500

If you do not know what created the DBF files, try using the built-in DBase driver.

If that does not work, try using FoxPro. As Greg said, you might have to download a driver for this.

Phil

BTW a flat file is just a text file - eg a CSV file.

____________________________________________________________________________________________

Help us to help you. For better, quicker and more focused answers to your questions, consider following the advice in this link:

http://www.sqlservercentral.com/articles/Best+Practices/61537/

If you are asking for help and your post does not contain a question, you should expect responses which do not contain any answers. Put a question mark in there somewhere - it's not rocket science.

Post #603977

Dhans

Posted Monday, November 17, 2008 4:14 PM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, April 09, 2013 11:20 AM
Points: 135, Visits: 247

Instead of using Import/Export wizard, You can import DBF files using SSIS Packages.
Steps:
1. Create an SSIS Package using BIDS.
2. In the Connection Managers
Right Click --> Create OLE DB Connection-->New--> In the Provider column, Select Microsoft Jet 4.0 OLE DB Provider--> Type the DBF file location in Database file name column.
for eg: C:\SSIS\DBFFiles\ (DO NOT TYPE THE DBF FILE NAME)
3. Press ALL button in left side --> Advanced-->Extended Properties Type : dbase 5.0 Press OK.
4. Now the Connection is created.
5. Create Destination SQL Server connection for storing the dbf data.
5. Drag the Data Flow task
6. In Data flow task, Drag OLE DB Source and OLEDB Destination tasks
7. In Ole Db Source, select the connection manager as newly created Dbase Connection.
8. Select your DBF File in Name of the table or View.
9. Connect OLE DB Source and OLE DB Destination and Map the Source and Destination Columns.
10. Run the Package..... thats all..

Post #604012

amacwan

Posted Monday, December 15, 2008 1:03 PM

Forum Newbie

Group: General Forum Members
Last Login: Friday, August 31, 2012 6:07 PM
Points: 1, Visits: 44

Hi,

Thanks for the posting. I am trying to import .DBF files into sql server 2005 using the same method. Can I also import .DBF files from access database where these .DBF files are linked?
I used the above method and using folders containing .DBF files. Connection is not set up, i m getting errors "...could not find installable ISAM"...please advise.

Thanks
Ashish

Post #619922

Jay_Noob

Posted Tuesday, February 03, 2009 9:22 AM

Valued Member

Group: General Forum Members
Last Login: Monday, July 23, 2012 7:54 AM
Points: 59, Visits: 236

I just wanted to throw out an FYI that tripped me up with something similar to this. We are running 64 bit servers and there is no 64 bit FoxPro driver. To run the package on a 64 bit server from BIDS I had to go to Project (menu bar) -> "project name" Properties -> Debugging and select False for the "Run64BitRuntime" option.

Post #648982

info-658497

Posted Wednesday, February 11, 2009 2:00 PM

Forum Newbie

Group: General Forum Members
Last Login: Tuesday, February 19, 2013 6:10 PM
Points: 2, Visits: 50

Hi Dhans, Thanks for the helpful post.

Is it possible to link my SQL table to the DBF file? My data is captured at the backend by a 3rd party app. I need to link to the app's files, and build the frontend from there.

Thanks again

Dhans (11/17/2008)