export to excel in stored procedure

  • Thread starter Thread starter Tony
  • Start date Start date
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!
 
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).
 
Back
Top