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).
 

Ask a Question

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.

Ask a Question

Similar Threads

Call stored procedure in SSMS from Access 2016 doesn't work. 0
Export a report to Excel via a cmd 1
Application.ExportXML 4
Stored procedure as row source for a combo box 4
Exporting data based on dynamic query 5
ADP filtered data export to Excel 0
Word to Excel: Export comments with text and line number 0
Cannot show a resultset produced by a stored procedure 2

Top