Post reply

How to Import .dbf to SQL2005 directly

  • 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

  • January 16, 2009 at 9:46 am

    #928291

    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 ...

  • January 16, 2009 at 10:17 am

    #928322

    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..

  • January 16, 2009 at 12:55 pm

    #928462

    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) ]

  • May 13, 2010 at 2:19 pm

    #1167193

    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.

  • May 14, 2010 at 5:51 am

    #1167444

    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

  • May 14, 2010 at 9:35 am

    #1167635

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

  • May 18, 2010 at 10:24 am

    #1168937

    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/

  • May 18, 2010 at 1:34 pm

    #1169073

    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.

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

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