Importing large files

[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

 

[ChrisBat]

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