Export to Multiple Tabs in Excel

[emz]

Hi All,

I was wondering if anyone could help me please?

I have information held in 3 different tables and I would like to extract this information to three different tabs in a singe Excel workbook - preferably in one step.

My access knowledge is fairly basic but I have been looking online and I can only find out how to do it using a VBA script - which is quite terrifying! Is there a simple way to do this?

Many thanks in advance
E

 

[namliam]

If you want to do this in one step, the vba script is the way to go...

VBA isnt all that terrifying, just about as scary as water if you have Water fobia.... once you get your feet wet, you will love it and want more