[ask] how to export some combined tables into .xls?

[coolbear91]

hi guys,
I'm still newbie in Access.

let's say, I need to combine data from Access' table named MessPkt and PerfMessung.
as they consist of hundred rows, I might gonna messed up if I had to combine them manually one by one.
is there any method about how to that and export the result into excel?
please help.

thx b4

 

[vapid2323]

If you are working with Access 2007:

Select the table you would like to export
Click the External Data TAB on the access ribbon
In the export section click on the little excel icon

A wizard will help with the next steps.