Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Microsoft Jet and OLE-DB
I use the Microsoft Jet engine to get data from Oracle directly into
Excel. It works fine with an ODBC connection but with very poor performances (compared to incredible perfs with SQL Server, but I've got to make this work with Oracle). I tried to specify the oledb provider instead of ODBC, but without success. It looks like it only works with odbc. The connection is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="Excel 8.0;HDR=Yes;" And the statement is: INSERT INTO [Sheet99$] SELECT * FROM [odbc;Driver={Oracle in OraHome92};DBQ=THIS.THAT;UId=SOMETHING;PWD=SOMETHI NG].THE_TABLE If you have any idea as by what I should replace [odbc;Driver={Oracle in OraHome92};DBQ=THIS.THAT;UId=SOMETHING;PWD=SOMETHI NG] to make it wirk with something else than ODBC, please let me know! Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Microsoft Jet and OLE-DB
Use the Oracle OLEDB provider. See
http://www.carlprothman.net/Default....leFromOr acle for details -- HTH RP (remove nothere from the email address if mailing direct) "DevInstinct" wrote in message oups.com... I use the Microsoft Jet engine to get data from Oracle directly into Excel. It works fine with an ODBC connection but with very poor performances (compared to incredible perfs with SQL Server, but I've got to make this work with Oracle). I tried to specify the oledb provider instead of ODBC, but without success. It looks like it only works with odbc. The connection is: Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Book1.xls;Extended Properties="Excel 8.0;HDR=Yes;" And the statement is: INSERT INTO [Sheet99$] SELECT * FROM [odbc;Driver={Oracle in OraHome92};DBQ=THIS.THAT;UId=SOMETHING;PWD=SOMETHI NG].THE_TABLE If you have any idea as by what I should replace [odbc;Driver={Oracle in OraHome92};DBQ=THIS.THAT;UId=SOMETHING;PWD=SOMETHI NG] to make it wirk with something else than ODBC, please let me know! Thanks |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Microsoft Jet and OLE-DB
Unfortunately, I tried it before and it's not working.
I tried: INSERT INTO [Sheet99$] SELECT * FROM [Provider=OraOLEDB.Oracle;Data Source=THIS.THAT;User Id=SOMETHING;Password=SOMETHING].THE_TABLE and INSERT INTO [Sheet99$] SELECT * FROM [odbc;Provider=OraOLEDB.Oracle;Data Source=THIS.THAT;User Id=SOMETHING;Password=SOMETHING].THE_TABLE There either something in the FROM clause that I miss or it's just not supported by the Microsoft Jet engine. Any further help is welcome. Thanks, Martin |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Microsoft Jet and OLE-DB
Why not just read it from the Oracle database and use VBA to dump the data
into Excel. Far simpler. -- HTH RP (remove nothere from the email address if mailing direct) "DevInstinct" wrote in message ups.com... Unfortunately, I tried it before and it's not working. I tried: INSERT INTO [Sheet99$] SELECT * FROM [Provider=OraOLEDB.Oracle;Data Source=THIS.THAT;User Id=SOMETHING;Password=SOMETHING].THE_TABLE and INSERT INTO [Sheet99$] SELECT * FROM [odbc;Provider=OraOLEDB.Oracle;Data Source=THIS.THAT;User Id=SOMETHING;Password=SOMETHING].THE_TABLE There either something in the FROM clause that I miss or it's just not supported by the Microsoft Jet engine. Any further help is welcome. Thanks, Martin |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Microsoft Jet and OLE-DB
It's Server-side work, shipping documents over the Internet in Excel.
Can't use OWC either :-( Thanks if you have anything else to suggest... Martin |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel, Microsoft Jet and OLE-DB
But you still have Excel on the server, otherwise how can you create Excel
docs over there? -- HTH RP (remove nothere from the email address if mailing direct) "DevInstinct" wrote in message ps.com... It's Server-side work, shipping documents over the Internet in Excel. Can't use OWC either :-( Thanks if you have anything else to suggest... Martin |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I covert Microsoft Word file into Microsoft Excel one? | Excel Discussion (Misc queries) | |||
Microsoft Visual Basic errors displaid when opening Microsoft Word 97 & Excel (7 | Setting up and Configuration of Excel | |||
Change individual cell heights/widths in Microsoft Excel 2000 like Microsoft Word | Excel Discussion (Misc queries) | |||
Microsoft Excel Viewer 2003 won't open Microsoft Excel Worksheet | Excel Discussion (Misc queries) | |||
How do I import Microsoft Word files into Microsoft Excel? | New Users to Excel |