How do I move data in columns (XL) to rows in Access table

  • Thread starter Thread starter Ross08
  • Start date Start date
R

Ross08

Hi
I have an Excel 2003 spreadsheet with columns-- Name, Date, Rating, Date1,
Rating1, Date2, Rating2, Date3,Rating3 -->etc up to -->Date7, Rating7.

In Access 2003 how can I import the above spreadsheet & end up with a table
with Name, Date, Rating - with the:

Date field of the table containing the data from the Date, Date1, Date2,
Date3 etc columns of the spreadsheet for that name.
Rating field of the table containing the data from the Rating, Rating1,
Rating2, Rating3 etc columns of the spreadsheet for that name.
The name in the s'sheet row can be repeated for each row of the table.


Thanks for any assistance
Ross
 
7 queries. One for each Date/Rating combination.
One other thing. For a true relational database design, you should have two
tables. One for the name and the other for the dates and ratings.
Use an Autonumber primary key for the name table and instead of the name in
the data/rating table, store the name primary key as a foreign key.
 
Back
Top