Subject: Queries export to excel
Posted By: ymeyaw Post Date: 4/21/2006 1:17:17 AM
hi, i had a problem to export queries result into spreadsheet. I know if i use transfer spreadsheet in access, all the queries result will put into diff worksheets. But i would like to write a macros so that all the queries will put under one spreadsheet. Can this be done?

Let say 1st query  will output to excel worksheet in column A1 and B1, and the 2nd query will output to C1 and D1. How can i do this? i really stress on this..:(




Go to topic 43044

Return to index page 308
Return to index page 307
Return to index page 306
Return to index page 305
Return to index page 304
Return to index page 303
Return to index page 302
Return to index page 301
Return to index page 300
Return to index page 299