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 |
|
ThreePea
Yak Posting Veteran
83 Posts |
 Posted - 2002-11-01 : 12:48:26
|
Hey everyone. Someone recently showed me a slick way to import Excel spreadsheets into a table. On our development box it works great. Here is an example: SELECT * FROM OpenRowset('MSDASQL','Driver=Microsoft Excel Driver (*.xls);DBQ=E:\Trace\auto5','SELECT * FROM [car$]') This retrieves the worksheet "car" from auto5.xls. However, when I run the same query on our production box, I get the following error:OLE DB provider 'MSDASQL' reported an error. [OLE/DB provider returned message: [Microsoft][ODBC Excel Driver] System resource exceeded.]Obviously, something is different between the two boxes. However, we have checked *everything* we can think of - ODBC drivers, MDAC versions, etc, etc. We even downloaded and ran Microsoft's Component Checker ([url]http://www.microsoft.com/data/download.htm#CCinfo[/url]) and it gave identical results. I just wanted to see if anyone had any thoughts on something else we could try. Thanks.Jerry==================================================Tolerance is the last virtue of an immoral society. -- G.K. Chesterton |
|
|
|
|
|
MSDASQL Driver problem when importing Excel file