Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spikekirk
Starting Member
1 Post |
 Posted - 2009-08-17 : 02:35:29
|
| HiI'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 1Cannot get the column information from OLE DB provider "MSDASQL" for linked server "(null)". |
|
|
Vinnie881
Master Smack Fu Yak Hacker
1231 Posts |
Posted - 2009-08-17 : 14:30:49
|
Follow Microsofts example.http://support.microsoft.com/kb/207595
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881 |
 |
|
|
daspeac
Starting Member
4 Posts |
Posted - 2009-11-20 : 08:54:22
|
quote:
Originally posted by Vinnie881
Follow Microsofts example.http://support.microsoft.com/kb/207595
Success is 10% Intelligence, 70% Determination, and 22% Stupidity.\_/ _/ _/\_/ _/\_/ _/ _/- 881
Hi Vinnie881, from my point of view, it is too complicated, have you heard about easier ways? For example, this job can be automated by the sql 2005 in recovery program that can be found here: http://www.recoverytoolbox.com/microsoft_sql_server_database_recovery_download.html, Recovery Toolbox for SQL Server quickly eliminates error messages and reindexes affected databases |
|
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2009-11-20 : 09:49:53
|
| how is that too complicated? |
|
|
|
|
|
|
|
|
Import dbf