C
Chris
Hi,
I've created a database and now have the task of filling it with
information. The initial spreadsheet I based my tables off only contained
1/10th of the data I needed (In this case Test specs for Rubber compounds).
The entire specs are in seperate (750 to be exact) excel spreadsheets which
relate to each compound. I don't particularly want to open and extract data
from 750 spreadsheets manually. Is there a way to code an import that opens
each spreadsheet and imports the cells (Which are the same in each case)? The
spreadsheets all contain the word " - Specs" which I'm hoping can be used to
identify them. I'm looking to place the imported data into a Table in access.
Thanks in Advance, hopefully this can be done otherwise It will be a long
couple of weeks..
Chris
I've created a database and now have the task of filling it with
information. The initial spreadsheet I based my tables off only contained
1/10th of the data I needed (In this case Test specs for Rubber compounds).
The entire specs are in seperate (750 to be exact) excel spreadsheets which
relate to each compound. I don't particularly want to open and extract data
from 750 spreadsheets manually. Is there a way to code an import that opens
each spreadsheet and imports the cells (Which are the same in each case)? The
spreadsheets all contain the word " - Specs" which I'm hoping can be used to
identify them. I'm looking to place the imported data into a Table in access.
Thanks in Advance, hopefully this can be done otherwise It will be a long
couple of weeks..
Chris