Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() I have to import data which has more than 70,000 rows. How can I import ? I beleive that you can import on 64k or 65k rows. Any suggestions ? Thanks |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() -----Original Message----- I have to import data which has more than 70,000 rows. How can I import ? I beleive that you can import on 64k or 65k rows. Any suggestions ? Thanks . You are correct on the row limits - precise limitations are available by looking up the specs in the help file. Consequently you won't be able to handle your imported data on one sheet if you put one record per row. Only suggestion would be to split the data up between multiple worksheets if that is practical. If not, maybe you need to use a database app instead. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import data from text file | Excel Discussion (Misc queries) | |||
Import only certain rows from text file | Excel Discussion (Misc queries) | |||
import data from a text file | Excel Discussion (Misc queries) | |||
Import only certain rows of a huge text file | Excel Discussion (Misc queries) | |||
Get External Data, Import Text File, File name problem | Excel Programming |