Urgent ! How to export more than 65535 rows to Excel ?

[Guest]

Dear All,

My colleague wants to export an access query and an table records into
Excel. But he can't finish this task. Then I have checked his query and table
records. I find that both tables and query records are more than 65535, so he
can't export these records into Excel normally.

I would like to ask that can I export more than 65536 records from Access
to Excel properly without develping any VBA codings ? Would you mind send
some reference websites to me?

Thanks

 

[Jeff Boyce]

Just one person's opinion ...

I believe Excel has a limit to how many rows it can hold. I believe you've
found that limit. I don't know of a way to stuff 6 pounds of flour into a
five pound sack...

 

[Craig Alexander Morrison]

The simplest way is to use SQL to create a series of queries that will split
your data into sets of less than 64K.

The split should be logical, say all records before and after a certain date
or all customers with names beginning A to L and then M to Z if you need to
split into more than two sets define the relevant ranges and then check that
the total number of records returned by each query adds up to the total
number of records in the original table.

You can export the output of a Select Query just as you can a table to
Excel.

Otherwise keep the data in Access and try to accomplish what you are
attempting without using Excel.

 

[Immanuel Sibero]

Otherwise keep the data in Access and try to accomplish what you are
attempting without using Excel.

This would be my approach. There is a reason why Excel was designed to
handle only 65000 records or so. If you need to work with 65000+ records,
for goodness sake, use Access. That's what Access is for, no?

Just curious, how do you analyze 65000+ records in Excel spreadsheet without
suffering from some kind of *information overload*?


Immanuel Sibero