importing from excel

[GoDawgs]

I've got a database table that looks like:
store month sales
x 1 1000
y 1 1000
with data on about 500 stores for each of the last 12 months, and i'm trying to import some data from excel that looks like:
store january february march etc
x 500 100 900
y 300 200 300

so basically i want to import column headings as a field for the record and then follow that up with the actual sales for that store and month...any ideas for how to do this, if this makes sense at all?

 

[lameid]

I would link the excel file and then use 12 append queries to get the data in the appropriate table.