Export to excel sheets

[jkwok]

Hi,

I have 5 tables in my database. I would like to be able to export the data from 4 tables into one excel file, where each table would be on it's own sheet.

Is this possible with just a macro group? Or would I have to do some VB coding here?

Thanks,
Jason

[cori25]

It is possible in a macro, you would have to do a transfer spreadsheet for each table and define which sheet it should go to.

Although, I try to avoid transfer spreadsheets and do it in a module.

If you need more assistance, just let me know.

Thanks

[jkwok]

Hi Cori25,

If doing it in a module is a better idea, then I'm up to trying it. Is there somewhere you can direct me to learn how to get this working?

Thanks,
Jason