I have run vb code to make several tables in access. Now I need to export them all to excel. Many of the tables would best be exported to the same excel file - different sheet.
e.g.
tables
emp_kansas
emp_ohio
emp_kentucky
est_kansas
est_ohio
est_kentucky
wages_kansas
wages_ohio
wages_kentucky
I would like to export the above 9 tables into 3 excel files with 3 spreadsheets each.
file one: Kentucky with sheets: emp, est, wages
file two: Ohio with sheets: emp, est, wages
file three: emp, est, wages
how can I do this in vb code?
