Excel to Access problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all,

I have an Excel sheet linked to my Access database.

Within the Excel sheet I have the headers and the data below. E. g.:
A B C D
1 P1 P2 P3 <= name e.g. Produkt
2 31.01.06 10 24 16 <= data
3 28.02.06 15 87 65 <= data

Within Access I would like to separate the name row and the data on two
different tables:

tblNames <= Table name from Table one

Name <= Field name & primary key
P1
P2
P3

tblData <= Table name from Table two

Name Data Date
P1 10 31.01.06
P1 15 28.02.06
P2 24 31.01.06
P2 87 28.02.06
......

Do you have any idea who I could do this?

Kind regards,

Simon Minder
 
Back
Top