Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Exporting to Excel 1

Status
Not open for further replies.

Buj123

Programmer
Jan 5, 2004
96
US
Hi,
Can any one tell me how to export three tables information in to same excel sheet.
Thanks
 
Buj123,

Take a look at the following link related to Excel automation. It will allow you more flexibility than using the OutputTo option of the DoCmd.

All you should have to do is modify the code for the other two tables you need and then specify the range or rows where you wish to write the data to.



HTH,


Steve
 
Thank you so much for your very helpful response. Thanks a lot star for you.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top