Newbie - Tricky importing from Excel problem

[Rogan]

I'm probably approaching this wrong, as I'm definitely out of my depth - maybe someone can offer some advice

I have 2 spreadsheets. One is a simple parts list with a code and some other info - I've loaded this into Access no problem.

The second sheet is used for ordering - it contains one text field with a company name at the top, followed by a list all in one column of all of the item codes, and another column with a description, and a third column with an x in against each item being ordered.

What I would like to do is set up a new table with the company name, and then each of the item codes which have been selected (there will always be a maximum of 10 ordered so I envisage a field per ordered item code).

I haven't got a clue how to do this - Can anyone help?

I can then link the two tables and print a report - I could probably do this bit.

Thanks for any advice

 

[buddythebest]

how abt u take a screen shot of the excel spreadsheet and show it here, because im not really sure how does it look like. Is it like:

Company name
item code x
item code
item code x
repeated in several columns (x if it is ordered)??