Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Importing data into Excel using MS Query John Excel Discussion (Misc queries) 0 August 8th 07 01:46 PM
Microsoft Query is lost when opening Excel 2002 file dlb Excel Discussion (Misc queries) 0 January 24th 07 12:29 AM
Importing Microsoft query data into excel changes linked rows Wazzy_bear Links and Linking in Excel 1 December 19th 05 09:09 AM
Importing data to Excel using MS Query John Excel Discussion (Misc queries) 1 November 17th 05 06:19 PM
Importing Microsoft Word File Names jrwaguespack Excel Worksheet Functions 3 March 16th 05 07:41 AM


All times are GMT +1. The time now is 08:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"