Software and Programs Thread, MS Query will not import to Excel 2003 in Software & Hardware , Games; I have a SQL query that I pasted into the MS Query ("MSQ") SQL text box and it runs fine ...

Short Link: http://forum.egypt.com/enforum/showthread.php?t=26461

newbe · 07-02-2009, 08:30 PM

I have a SQL query that I pasted into the MS Query ("MSQ") SQL text box and it runs fine an renders the correct data in the MSQ box. When I click the little MSQ icon to have it link up to my Excel sheet it seems to link but when executed in Excel...

I have a SQL query that I pasted into the MS Query ("MSQ") SQL text box and it runs fine an renders the correct data in the MSQ box. When I click the little MSQ icon to have it link up to my Excel sheet it seems to link but when executed in Excel it just sits there. No data. Is it because I have a prewritten query? The link-up doesn't seem to have a problem coughing up data for a whole table if I use their little wizard, but my queries are fairly complex and the wizard is a bit too simplistic. Any thoughts would be appreciated. Thanks!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)

Software and Programs Thread, MS Query will not import to Excel 2003 in Software & Hardware , Games; I have a SQL query that I pasted into the MS Query ("MSQ") SQL text box and it runs fine ... Short Link: http://forum.egypt.com/enforum/showthread.php?t=26461