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

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
Accessing Stored Procedure via VBA 5
Stored procedure as row source for a combo box 4
Export recordset from ADP project 4
Word to Excel: Export comments with text and line number 0
returning records in store procedure 2

Back
Top