export several tables to one xls workbook

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

Guest

I want to export two Access tables to one xls workbook with two worksheets.
Does anyone know how to do it? I use the "DoCmd.SendObject" for one table.

Thanks,
Jim
 
Use TransferSpreadsheet (macro or VBA) two times in a row. Specify the same
xls file each time. So long as the table names are different, ACCESS will
write their data on separate worksheets.
 
Thanks Ken,
Just what I needed.
Jim

Ken Snell said:
Use TransferSpreadsheet (macro or VBA) two times in a row. Specify the same
xls file each time. So long as the table names are different, ACCESS will
write their data on separate worksheets.
Click to expand...
 
I am using this method to transfer several tables but the entire table is not
being transferred; only 16,384 records are being tranferred for each table.
Shoul I be defining a range of some sort? If so, how?
Thanks.
 
Back
Top