In my application, I am getting ready to start working on the portion that deals with my vendors. Each vendor we use generally sends us their quote as a PDF along with the Excel file. Unfortunately, each vendors format for their given files are different than the others. Only one has a format that could be directly imported with no problem.
Now my question begins. Based on the fact that each vendors excel/pdf format is different, I assume the best course of action would be to make a table for each vendor and make it match their file. The next issues arises due to the fact the several of them have all of their company info as headers and such. Is there a way during the import process (that I eventually want to make happen via clicking a button and selecting the file), to start at certain lines within the excel document? Say vendor A has company info and headers from line 1 to 28, nothing until line 32, then the actual data I want to important starts at 38. In the 10 years I have done this, the vendors file has never changed format wise.
Is there a way to do this? Or are PDF's possibly easier to work with? Although I highly doubt that one. One of the main things my boss wanted (almost demanded) was the ability to import this data, as it is what takes up a large chunk of our time, as manually putting all it in can be very time consuming.
Also, there are essentially only 5 fields from each that I need to grab. Designation, quantity, manufacturer, product code, unit price. What order those are in on their file varies from vendor to vendor however.
Now my question begins. Based on the fact that each vendors excel/pdf format is different, I assume the best course of action would be to make a table for each vendor and make it match their file. The next issues arises due to the fact the several of them have all of their company info as headers and such. Is there a way during the import process (that I eventually want to make happen via clicking a button and selecting the file), to start at certain lines within the excel document? Say vendor A has company info and headers from line 1 to 28, nothing until line 32, then the actual data I want to important starts at 38. In the 10 years I have done this, the vendors file has never changed format wise.
Is there a way to do this? Or are PDF's possibly easier to work with? Although I highly doubt that one. One of the main things my boss wanted (almost demanded) was the ability to import this data, as it is what takes up a large chunk of our time, as manually putting all it in can be very time consuming.
Also, there are essentially only 5 fields from each that I need to grab. Designation, quantity, manufacturer, product code, unit price. What order those are in on their file varies from vendor to vendor however.