export to excel in stored procedure

T

Tony

Hello!
Does anyone have an example of exporting data from an
Access project database to Excel??
Or maybe this is not possible??
I am trying to get around the record limit that I hit
exporting via a macro, thinking that maybe a stored
procedure wouldn't have the same constraints.
Thanks!
 
V

Van T. Dinh

The row limit is the Excel limit, not because of the macro. For example,
Excel8 (i.e. Excel 97) is limited to 64K rows and (not sure here) I don't
think the limit has been increased with Excel9 (2000) or Excel10 (2002).
 
Top