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 |
|
lilinikco
Starting Member
28 Posts |
 Posted - 2010-12-08 : 01:27:04
|
| Hi all.we want import excel files to sql server 2008 which running on windows server 2008,with script such as opendatasource or openrowset and msdasql and microsoft.Jet.OLEDB.4.0, but for jet oledb get error:microsoft.Jet.OLEDB.4.0 has not been registered and for msdasql get error:OLE DB provider "MSDASQL" for linked server "(null)" returned message "[Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified".Cannot initialize the data source object of OLE DB provider "MSDASQL" for linked server "(null)".which provuder use?plz give me a script that works correctly and not returns error.lili@@ |
|
|
|
|
|
read excel to sql server2008 and win server2008