Feb 14, 2004 #1 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
Feb 14, 2004 1 #2 SteveR77 Programmer Sep 18, 2000 813 US 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. http://www.mvps.org/access/modules/mdl0035.htm HTH, Steve Upvote 0 Downvote
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. http://www.mvps.org/access/modules/mdl0035.htm HTH, Steve
Feb 14, 2004 Thread starter #3 Buj123 Programmer Jan 5, 2004 96 US Thank you so much for your very helpful response. Thanks a lot star for you. Upvote 0 Downvote