Microsoft Query Hangs when adding table
Posted: 07 Jan 2007, 17:54
Hi,
I have a problem with Sage Link to Excel and MSQuery
I open the Excel Query Wizard and Add columns from the INVOICE table
I then edit the query in Microsoft Query
In Microsoft Query I press the 'Add Table(s)' button and select the INVOICE_ITEM table.
When I press the 'Add' button MSquery hangs.
It appears to only hang when selecting the INVOICE and INVOICE_ITEM tables.
Is it because of some relationship between these tables?
I am running Sage Line 50 Financial Controller V11.01.0030
I have a problem with Sage Link to Excel and MSQuery
I open the Excel Query Wizard and Add columns from the INVOICE table
I then edit the query in Microsoft Query
In Microsoft Query I press the 'Add Table(s)' button and select the INVOICE_ITEM table.
When I press the 'Add' button MSquery hangs.
It appears to only hang when selecting the INVOICE and INVOICE_ITEM tables.
Is it because of some relationship between these tables?
I am running Sage Line 50 Financial Controller V11.01.0030