Importing large files

  • Thread starter Thread starter Chris B
  • Start date Start date
C

Chris B

When I try to import a large file the wizard will allow
me to get data upto 65536 rows. However when I try use
the wizard again it won't let me start the row at
65537 ..tells me that it's an invalid integer.

Help please !
Thanks in advance
 
Hi Chris,

Unfortunately, 65536 is the maximum number of rows that are allowed i
Excel. I suggest either using Access (which allows for pretty much a
many rows as you need) or by chunking the data into logical subsets
i.e. 1 month/area/person/etc. per worksheet.

Hope this helps!
Chri
 
Back
Top