TransferSpreadsheet

[08211987]

Can a TransferSpreadsheet export a Access table like it can a Query? I am working with many many rows of data and I am thinking either Excel or Access is timing out so I thought if I would create the result of the query first in a table and then do the transfersheet using the table name instead of the query that it might solve the issue. But the resulting worksheet was empty.

Thanks,
C

 

[swtrader]

I'm unclear if you are using Access or Excel as the source of the code. Are you trying to export from Access to Excel (using Access) or import into Excel from Access (using Excel)? And I'm not sure what is timing out. With some clarification, we can help you.

swtrader
-- If you don't know where you're going, you'll always know when you're not there.

 

[08211987]

I am exporting data from Access into an Excel spreadsheet and doing some formatting to the spreadsheet using VBA within Access. My Transferspreadsheet export cmd in Access is exporting a query and sometimes Access just shuts down at that command. I am thinking if I run DoCmd Open Query first and create a table then see if the transferspreadsheet can export the table that it might take up less resources or something?

Thanks,
C

 

[08211987]

I'm wondering if in the example below, once I run the below query, can I acExport table tbl_App_Div?

'the below appends query results into table "tbl_App_Div"
DoCmd.OpenQuery "qry_Append_App_Div"
DoCmd.TransferSpreadsheet acExport, 10, "tbl_App_Div", "c:\data\app.xlsx", False, "Data2