Interpreting a spreadsheeting into an Access Table

[Andrea001]

Wondering if anyone can help? I need to import data into an Access table(s) from an Excel spreadsheet and I'm having trouble determining fields. My spreadsheet has months as column headers, modalities as row headers and the data is # of procedures done. Another row header is the location where the modality is performed. Here's an example:
Jan Feb Mar Apr
Loc1 xray 4 6 5 8
CT 9 4 7 3
Mammo 2 8 4 6
US 5 7 9 6
Loc2 xray 5 6 8 6
CT 3 4 2 5
Mammo 5 12 3 3
US 6 3 4 6

How do I pull this into access so that I can manipulate the data with queries?
Thanks,
Andrea

 

[Isadore]

Andrea - try a keyword search using "Excel Import" etc... there are several out there...looked at several the other day..I believe I saw about 1/2 dozen relating to your problem. Keep us posted.

 

[Andrea001]

Thanks for the suggestion, I'll get to work!!