Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Import data files larger than one spreadsheet maximum?
We are trying to import a very large (e.g., 1.4 million rows) data file into
Excel. This exceeds the row limit in Excel. Is there a solution without going to Access that would permit creating sequential; i.e., the data could span or be linked across multiple spreadsheets. Thank you, Bob |
#2
|
|||
|
|||
Bob
It cannot be done easily... what are you trying to achieve? If it is a final summary report, then consider using ODBC from your data source into an Excel pivot table. I bring 250,000+ each week and it works great. If you are just looking to bring in flat data...honestly... you have the wrong tool. You should look at Access (At least) -- HTH Nick Hodge Microsoft MVP - Excel Southampton, England HIS "Bobby Joe Mo" <Bobby Joe wrote in message ... We are trying to import a very large (e.g., 1.4 million rows) data file into Excel. This exceeds the row limit in Excel. Is there a solution without going to Access that would permit creating sequential; i.e., the data could span or be linked across multiple spreadsheets. Thank you, Bob |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
import data from txt file , the data prefix with plus "+" | Excel Discussion (Misc queries) | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Import External Data | Excel Worksheet Functions | |||
how do I print data in a spreadsheet data base to a mailing lable. | Excel Discussion (Misc queries) | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |