Excel query not responding

M

mckzach

I am attempting to create an Excel query (using Query Wizard) by importing
about 130 columns of Excel data (only 50 rows or so). However, at the point
where I reach the Query Wizard-Finish dialog box, then click on the 'Save
Query' button, nothing happens. No error message, no hourglass, nothing.

I've built numerous queries before and have never experienced this problem,
though I've never had a data table of 130 columns before. Is that the
problem; too many columns??

Are there any work-arounds to this issue? Any alternatives??

Thanks all
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

MS Query 7
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
ODBC error 100 when accessing Bookkeeper version 15 software (accounting software using Access dbase) 0
bug - named ranges point to wrong column after being moved inside anMS Query Table 0
Excel Macro Problem 2
Forcing Excel to Import .CSV data 2
Querying multiple Excel files 5
MS Query has data, but does not transfer it to Excel 2

Top