Is there a way to import only certain cells within excel and not an entire excel worksheet into access. These specific cells within one file are all totals of a list of costs incurred and these totals are all owned by one unique id (product id, which is listed within the excel spreadsheet). Although, there are multiple spreadsheets that I need to pull this data from (one spreadsheet for each product code). A person inputs the data (costs) for this specific product into this standard excel spreadsheet, the spreadsheet calculates the totals. The position of the specific cells can possibly change depending on how many different costs are involved, therefore adding rows to the spreadsheet. I would like to create a table that pulls these cells from excel and uses the product id as a primary key which can then be linked to another table within access. I'm a little inexperienced with access. I hope someone can help! Thanks in advance!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
importing/linking excel fields into access
- Thread starter Data
- Start date
Similar threads
- Solved
