Excel to Access problem

[Simon Minder]

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

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "NormalizeDenormalize.mdb" which illustrates how to do this.

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L