Jet Essentials 2013
Excel 2010
I have a Jet report which runs each night. Now I want to link this data with another Excel workbook to created a summary. (Ultimately several Jet reports into a summary Excel sheet). Using the Data > Connections > Add from Excel, it does create a link to my Jet report, however, when I add that connection to my new Excel workbook, it adds all the metadata from the Jet report, i.e, the first few rows and columns, and all I want is the actual table data.
On a side note, the first couple of times I tried to create the data connection it brought up dialog regarding an OLE DB, which I could not get to work. Then, without me doing anything differently (not that I can recognize), the third or fourth time it created the connection to the Jet report just as if it were any other Excel sheet. It was at this point I got the metadata mentioned in the paragraph above.
Please advise the correct steps to link Jet report data to another Excel workbook.
Thank you,
Chris
Date
Votes
2 comments
-
Jet Reports Historic Posts I've run into this issue as well in the first Jet table report I built (with the sole purpose being to be able to link it to another workbook). Did you find a solution to your problem?
-
Jet Reports Historic Posts Hi Chris,
Connections between workbooks can cause serious performance problems and they are not portable (since they depend on the 2 workbooks staying in the same folder structure), so it is generally not a recommended thing to do. Usually, if you want summary data in a workbook, I think it is recommended to just create the Jet formulas you need in that workbook to get the data.
That being said, you can actually create links between 2 workbooks. You just open both workbooks side by side and in the one workbook you use excel to select cells in the other workbook. You don't need to create an OLE DB or ODBC connection (which as you've seen won't give you what you want anyway. Does this make sense?
Regards,
Hughes
Please sign in to leave a comment.