How to Import .dbf to SQL2005 directly

Question

How to Import .dbf to SQL2005 directly

Manu-989313

SSC Rookie

Points: 29
More actions
January 15, 2009 at 4:47 am

#198469

Can we port any dbaseIV (.dbf) file to SQL Server 2005 directly. Is Microsoft provides any drivers for it?
I have a .dbf file containing 1 lakh records & i want 2 directly port it in SQL2005.
MANISH

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Michael Irwin SSC Veteran Points: 295 More actions · Answer 1

I don't know how many records you have ("1 lakh" ! 🙂 ) but you can import DB4 into Access easily enough, and then check it and then pull it into MS SS 2K5. That might be the easiest ...

steveb. SSC-Forever Points: 46733 More actions · Answer 2

1 Lakh = 100,000 in the Indian numbering system

as mentioned you can not do this directly, either use linked servers or SSIS

MS does provide a driver for .DBF files..

Michael Irwin SSC Veteran Points: 295 More actions · Answer 3

Thanks, Steve - I wasn't aware of the quantity of a lakh. Now I am. One lives and one learns.

Mike

[ “It is not because things are difficult that we do not dare, it is because we do not dare that things are difficult.” (Seneca) ]

chaudharyabhijit Ten Centuries Points: 1314 More actions · Answer 4

Hi Guys,

I want to import data from a .DBF file to SQL Server 2005. I have read a lot of forums and most of them say the same thing.

Using SSIS create a Connection Manager > Select Provider Native OLE DB\Microsoft Jet 4.0 OLE DB provider > All - Advanced - Extended Properties- dbase IV > Create a OLEDB Source and Destination > ---------------This is where the problem starts, after i select the OLE DB connection manager and goto Name of the table of the view, i get an error message that says this is not a valid path. I read somewhere that since i am using a 64 bit machine this error is because of that so i went to project > properties and changed the debugging> Run64BitRuntime to False.

But i am still not able to do it.

Can anyone help with this.

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 5

Have you tried using the Visual FoxPro OLE Driver. You may have to install it, and it can be found at:

http://www.microsoft.com/downloads/details.aspx?FamilyID=e1a87d8f-2d58-491f-a0fa-95a3289c5fd4&DisplayLang=en

chaudharyabhijit Ten Centuries Points: 1314 More actions · Answer 6

I downloaded the latest foxpro drive, but it still is showing me the same error!

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

If I'm not mistaken, I think you have to select the folder containing the DBF file(s), not the file itself. Then each DBF file will be displayed as separate table for selection.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

chaudharyabhijit Ten Centuries Points: 1314 More actions · Answer 8

CozyRoc you solved my biggest problem today.

Though it does ask you to select a file, however if you goto advanced and delete the file name, then OLEDB Source does see the file...Thank you so much.