Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ADOBE Connection to open Excel workbook
Hi All,
Windows 7 64 Bit, Office 2007 32 Bit, All updates for Windows & Office installed. I have am building a reasonably complex workbook in which an sql query is run on a sheet within the same workbook. I have used the connection string below and l am led to believe that this is the latest version which supports Excel 2007 & 2010 and removes the limitations of the 65536 rows / records. ADODB.Connection.Open "driver={Microsoft Excel Driver (*.xls, *.xlsx,*.xlsm,*.xlsb)};driverid=1046;dbq=MyExcelFi le.xlsm;" On my home computer where l developed the solution everything runs perfectly. On my colleagues laptop which has EXACTLY the same software installed (we have both checked the software version numbers several times) Excel crashes when the recordset exceeds 65536 rows! It would appear that the only difference in the 2 machines is the amount of ram available. The machine working has 16gb the machine not working only has 2gb. However l believe that Excel 32 bit is restricted to 2gb anyway. The data source files are xl2003 but to overcome the issue that Excel interprets this data as xl2003 data the whole workbook in which the qery exists is saved as a xl2010 file before executing the query. Anyway this doesn't answer why it should work on 1 machine but not another. Anybody got any idea's, this has really got me stumped! Regards Michael |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to force users to open pdf in adobe through excel | Excel Discussion (Misc queries) | |||
force users to open pdf in adobe rather than IE in excel | Excel Discussion (Misc queries) | |||
Excel 2003 hyperlinks to Adobe files fail to open | Excel Discussion (Misc queries) | |||
Adobe inserting into Excel causing the adobe file to be low dpi | Excel Discussion (Misc queries) | |||
Open a password protected excel workbook from second workbook to fetch data using dynamic connection | Excel Programming |