ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   MS Query - Add Table - Hangs/Not Responding (https://www.excelbanter.com/excel-discussion-misc-queries/197481-ms-query-add-table-hangs-not-responding.html)

Mathew P Bennett

MS Query - Add Table - Hangs/Not Responding
 
Good Evening All, Excel 2007 / Sage Line 50 V13.02

I am having trouble with adding a table to my MS Query of a Sage Line 50
database.
When trying to do so, the query hangs. I know the hour-glass should be on
for a period,
but I have given up after 2 hours & 1.5 hrs. Not Responding!!
My Query is not large, just two tables (so far), with the master sheet
having 35,000 rows (the no of transactions from Sage).

Any help please
Thank you
Mathew




All times are GMT +1. The time now is 03:08 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com