Hi
65536 rows is the maximum for one spreadsheet. above that you ned to
split the data on several worksheets.
One workaround to do this: Split the source file with your favourite
text editor to several files and import them individually
If you have that many records then I am assuming they are in database format, in
which case if you have Access you could dump them in there and then query them
from Excel with a Pivot Table or just an ordinary MSQuery. You may even be able
to query them from Excel right where they are now, but it depends on where they
are stored.
Really depends what the data is and what you want to do with it, or get out of
it.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
