Export to Excel from Access .adp project

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access 2000 project (.adp file) as client with a SQL server 2000 back end. I want to do export from one of the big tables of the database via the client to excel. On SQL Server 2000 I have created a stored procedure that selects the records to be exported. On the client I use DoCmd.OutputTo with the stored procedure as source

The problem is that this kind of export (DoCmd.OutputTo) seems to be limited to 10000 records. When the stored procedure selects 12000 records only 10000 are exported

Is there another way to do export to avoid this limit? I need to do the export via the Access client, not on the server itself. I could also make use of comma or semicolon separated files or other types of files if this could solve the problem

Regard

Tore G
 
Hi Tore,

Thanks for your post. According to your description, I understand that you
want to export (DoCmd.OutputTo) data to Excel from your client (Access adp)
but not server side. However, it seems the data set is limited to 10000
records. If I have misunderstood, please feel free to let me know.

Based on my research, this issue is mostly like a problem with Access 2000.
The easiest workaround is filtering down to a smaller recordset. However,
if you feel it is more convenient for you to use the large record set (>
10k records), please check to see if DoCmd.TransferSpreadsheet method can
meet your requirements. This works to send the whole table, but the
DoCmd.TransferSpreadsheet method will not allow you to use a view, even
though you can use a view in an MDB file. We can only use
TransferSpreadsheet method to export a table or an Access Select Query.

Thanks for posting in community.

Thanks & Regards,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
Back
Top