G
Guest
I was wondering if I could get some recommendations.
I have a need for an application where a varying number of Excel files are
placed into a location and the information from a summary spreadsheet in each
is extracted into an Access table so that it can be used only for reports
(part number listings, average prices, etc.). I do not need to update any
information once it is imported (linked?). It would be nice to be able to use
the same table and simply write over the information for each new gathering
of files to be evaluated.
The format for the Excel spreadsheets is standardized with the information
beginning at row 16. The information is essenitally a bill of materials with
columns for part number, description, price, etc. At the bottom of each
grouping of parts there is a summary row depicting a group price. As we have
developed many of these workbooks, so it is not feasable to manually change
their formatting.
I am very new to Access and would appreciate any direction people are
willing to give. Thank you!
I have a need for an application where a varying number of Excel files are
placed into a location and the information from a summary spreadsheet in each
is extracted into an Access table so that it can be used only for reports
(part number listings, average prices, etc.). I do not need to update any
information once it is imported (linked?). It would be nice to be able to use
the same table and simply write over the information for each new gathering
of files to be evaluated.
The format for the Excel spreadsheets is standardized with the information
beginning at row 16. The information is essenitally a bill of materials with
columns for part number, description, price, etc. At the bottom of each
grouping of parts there is a summary row depicting a group price. As we have
developed many of these workbooks, so it is not feasable to manually change
their formatting.
I am very new to Access and would appreciate any direction people are
willing to give. Thank you!