September 25, 2012 at 6:50 am
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
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
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy