[AccessD] Access to Excel 65K row barrier

> On Apr 2, 2014 9:09 PM, "Access Pro" <accesspro at cox.net> wrote:
>>
>> Thanks to all who responded.
>>
>> It has to be Excel.
>> It has to be 10K+ rows/records.

I am thinking you mean 100k+?

Btw, Should have been obvious but I will state anyway, my post below
implies writing to several sheets.

Very easy also, just keep your export workbook handy any time you do this
and always delete the data and re - export to it.
On Apr 2, 2014 9:26 PM, "Bill Benson" <bensonforums at gmail.com> wrote:
>
> You can put the macros in your excel 2003 worksheet that the client calls
from a button click to pump the data to a new excel (xlsx) file and close
itself. Very simply.