August 17, 2009 at 12:48 am
Hi
I'm trying to import data from dbf files into sql 2005 tables. I'm using the following syntax to import all the files,although some files import but others are producing the following an error. Any help would be much appreciated.
SELECT
* FROM OPENROWSET('MSDASQL','Driver={Microsoft dBase Driver (*.dbf)};DBQ=C:\Med2000\029\','SELECT * FROM FMDDR')
OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC dBase Driver] Unexpected error from external database driver (10023).".
Msg 7350, Level 16, State 2, Line 1
Cannot get the column information from OLE DB provider "MSDASQL" for linked server "(null)".
August 17, 2009 at 8:04 am
Duplicate post. No replies to this thread please. Direct replies to:http://www.sqlservercentral.com/Forums/Topic771726-338-1.aspx
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply