Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Microsoft Query is not importing all data from an excel file
I'm trying to import data from an *.xlsm file, using Microsoft Query, but the
data table created in my worksheet is missing the last 15-20 rows from the source. The overall size of the source worksheet is about 30 columns by 3500 rows. I've tried re-entering the data in the source, and re-ordering the rows but the problem persists. Is there a much lower limit to the amount of data I'm able to import than I thought? Any suggestions welcome |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Importing data into Excel using MS Query | Excel Discussion (Misc queries) | |||
Microsoft Query is lost when opening Excel 2002 file | Excel Discussion (Misc queries) | |||
Importing Microsoft query data into excel changes linked rows | Links and Linking in Excel | |||
Importing data to Excel using MS Query | Excel Discussion (Misc queries) | |||
Importing Microsoft Word File Names | Excel Worksheet Functions |