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


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
 
Ad

Advertisements

K

Klatuu

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.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top