Database Structure

Hello...

I've got Excel Sheet that got information stored in the form of Months i.e.

Jan Feb Mar etc.
12
350 43
34 45


How do i create tables in Access that corresponds the same situation!

Thanks...
Nauman Ahmed

According to me the table structure should have the following
fields

month,data1,data2,data3 .....

so if you need all the data from month jan you could have
query like

select * from monthtable where month = "jan"

another option
if you dont know now many data need to be stored for each
month

you stucture could be something like this

month,data

this table shall have each record for one data

hope this helps

cheers

jayesh jain