Question exporting each field of my access database to an excel by with different format

[driftking]

hello,

need help about an issue.

i actually have an ms access database with the following format(assuming)

title1 title2 title3 title4 title5 title6
1a 1b 1c 1d 1e 1f
2b 2b 2c 2d 2e 2f
3a 3b 3c 3d 3e 3f
4a 4b 4c 4d 4e 4f








for each row in the ms access database above i need to retrieve an excel in the format below

title1 1a
title2 1b
title3 1c
title4 1d
title5 1e
title6 1f


title1 2a
title2 2b
title3 2c
title4 2d
title5 2e
title6 2f


and so on....

Any suggestion from where i can proceed,what tool can i use??

thanks in advance

 

[driftking]

Alright,
i reform my question(now that myself have understand the issue clearly ).

i have an access database with a table containing data.
assuming i have 100s of rows in it.
What i want to do is for each row in the table i want to generate an excel sheet with specific fields in the database match specific cell in the excel template(please find attached).

That is if i have 1 hundred rows in my access database....i have to generate 100 excel sheet and rename it automatically with 1 of the field in my database(find an example attached)

i was thinking of making a form in ms access with button in it. on_click (event) it must loop through the database rows and generate excels according to the number of rows.

can you suggest me a solution or how can i realise my idea

ps: i have never work with access form before

attachment
1 ms access(contactDB) : from which i have to extract data
1 excel(<NOM DU CONTACT>the field name from the ms access db): the template