Not able to export Query report in access

[narendrabr]

Hi,



I am not able to export query report evn though the table is small.
Please help on this.
Thanks

[ranman256]

What are you trying to export, a table, a query, or a report. You mentioned all 3.
Qrys /tables export with

DoCmd.TransferSpreadsheet acExport, acSpreadsheetTypeExcel12, vQry, vFile, True, pvSheetNAme

[NoellaG]

Hi,

looking at the error message, it seems to me that your query result is to large. Maybe you use several tables without the proper joins? It might help if you add the SQL instruction of your query to the post.

[narendrabr]

I am trying to export a query result.
The size of the table is 20MB
Thanks

[narendrabr]

No it is pretty small just abut 550 records and rwo tables.

Thanks,
Narendra

[NoellaG]

Are there some complex calculations in the query?
Something you could try: convert the query to a make table query and then export the table result.

[narendrabr]

Can you please provide the steps to do this.

Thanks