I have several excel files that are quotes for different parts for customers. They are all setup the same with the info I want out in the same cell position in each spreadsheet. is there any way to pull the info I want out of all the spread sheets at once to create some type of database so that I can use the data easier? HELP!
It depends a bit on what database you are working on.
This works in DB2 and Infromix.
You must create a table for your customers with the same amount of fields you defined in your excel sheet.
Save your sheet as a comma-delimited file.
Load it into the database.
load from 'file.csv' DELIMITER ','
insert into customers
With DB2 you could use the load and import command.
Check with 'db2 ? load'.