I am fairly new at this but I am flummoxed as to what to do.

Here is the problem
I have ±25 Excel spreadsheets with item pricing on them.
I want to import these into 3 separate tables. (this will be a continuing task as prices are updated from supplier)
each sheet has ± 79x11 prices = 869



Spreadsheet: ________________ Type1__Type2__Type3__Type4__ Type5__etc, etc
________________________Oak $21____ $23 ____$11____ $9 _____$22___ etc.etc.
_______________________Maple $16 ____$29__ __$14___ $16_____ $44___ etc.etc
________________________etc
________________________etc
________________________etc

Table FURNITURETYPE is to be the first EXCEL Row Type1,Type2,Type3, etc [Note: FurnitureType is descriptive eg. Bed1,Chair2,Desk, Drawer etc]

Table WOODTYPE is to be the first EXCEL Column OAK, MAPLE, PINE........
Table PRICING is to be the intersection of the Rows & Columns

Thanks for the help

Hi Ross, Welcome to Utter Access



why are you planning on >1 table for pricing?

once you import your data into Access, you can use APPEND queries to get the information in a vertical format where "type1", "Type2", etc are records and not fields

you can get some ideas on APPEND queries here

link_Append Query to add records to subform
http://www.utteraccess.com/forums/showflat...;Number=1037490