Post reply

Import data from .dbf file to sql server 2005

  • September 25, 2012 at 6:50 am

    #262924

    Hi All,

    Can anyone please tell me how to import .dbf file to SQL server using SQL query open row set or bulk insert. I don't want to use the SSIS to do this.

    Please help me .

    Thanks

    Narayana

  • September 25, 2012 at 7:22 am

    #1541851

    check the following URL may be useful to you

    http://social.msdn.microsoft.com/Forums/en/transactsql/thread/a49fc6d8-7631-4d74-a2fa-7c4211dbcac6

  • September 28, 2012 at 12:46 pm

    #1543589

    Hi ,

    Openrowset works fine on 32 bit machine/server to import data from dbf file to sql server database.

    SELECT * FROM OPENROWSET(

    'MSDASQL', ' Driver={Microsoft dBASE Driver (*.dbf)};

    DefaultDir=c:\Testfolder; SourceType=DBF', 'SELECT * FROM employee')

    but its not working on 64 bit machine. Any ideas how to use openrowset/openquery on 64 bit server.??????

    I need to automate the import of data from dbf file to sql server database using jobs and sql scripts.

    Any help will be greatly appreciated

    Thanks

Viewing 3 posts - 1 through 2 (of 2 total)

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