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
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