Excel File

[]{ronic]

Hi

 

Re: Attached file

 

I get sent a excel file as attached each day updating products and stock levels and prices..

 

I am trying to find away to dump that file into my database without having to restructure the excel file. It needs to be in the data base in such away that I can create a popout menu with the headings you see in the file i.e

 

CPUs :: Intel

CPUs :: AMD

 

etc etc

 

to filter the procucts in my shopping cart..

 

I have 3 tables atm, maincat, subcat and products.. But it takes way to long to try and manually sort the changes.

 

Any Ideas on how I can do it by just dumping the excel file?

 

 

[attachment deleted by admin]