export in Excel

B

Bisha

I'm trying to export some data from an Access Table to Excel.
The export works but each record appears one after the other vertically .
How can I make that record are exported in columns one after the other
horizontally ??

rec1
1
2

rec2
4
5

I want it like this :

rec1 rec2
1 4
2 5
 
Top