export several tables to one xls workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jimtotem - 17 Mar 2005 04:29 GMT

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

Reply to this Message

Ken Snell [MVP] - 17 Mar 2005 04:56 GMT

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.

Signature

Ken Snell
<MS ACCESS MVP>

>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

Reply to this Message

jimtotem - 17 Mar 2005 06:19 GMT

Thanks Ken,
Just what I needed.
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
[quoted text clipped - 6 lines]
> > Thanks,
> > Jim

Reply to this Message

Diane - 27 Feb 2008 13:53 GMT

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.

> Thanks Ken,
> Just what I needed.
[quoted text clipped - 10 lines]
> > > Thanks,
> > > Jim

Reply to this Message

Jeanette Cunningham - 28 Feb 2008 21:13 GMT

Diane,
here is a link to a post with a how to for this problem:

http://groups.google.com/group/microsoft.public.access.externaldata/browse_threa
d/thread/734c0e82a0c4dbe8/e7293bef587ca94e?lnk=gst&q=export+to+separate+workshee
ts#e7293bef587ca94e

post back if you have further questions.

Jeanette Cunningham

>I am using this method to transfer several tables but the entire table is
>not
[quoted text clipped - 20 lines]
>> > > Thanks,
>> > > Jim

Reply to this Message