LUIS FREUND
asked on
Importing data from certain cells to a table in access
Wanted to import certain cells from an excel worksheet to a table in access:
On Capacity Exel attachment the cells highligthed in orange are the ones I would like imported to the a table called "tbl_SUPPLIER_CAPACITY". I've manually entered the data from the excel sheet to the table to illustrate what I was hoping for.
See both attachments fo Excel and sample database.
C--Users-lfreund-Documents-EE-Capac.xlsm
C--Users-lfreund-Documents-Capacit.accdb
On Capacity Exel attachment the cells highligthed in orange are the ones I would like imported to the a table called "tbl_SUPPLIER_CAPACITY". I've manually entered the data from the excel sheet to the table to illustrate what I was hoping for.
See both attachments fo Excel and sample database.
C--Users-lfreund-Documents-EE-Capac.xlsm
C--Users-lfreund-Documents-Capacit.accdb
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
um....might be a bit of a tough row then. Code is straight forward enough and we can probably work through it though.
But why don't you try the TransferSpreadsheet action in a macro and see if it gets you the data you need (easy enough to check). If not, you'll need to learn some VBA coding.
Jim.
But why don't you try the TransferSpreadsheet action in a macro and see if it gets you the data you need (easy enough to check). If not, you'll need to learn some VBA coding.
Jim.
ASKER
I'll give that a try....thank you for the help
ASKER
thank you for the response. I don't code in VBA. Any help would be greatly appreciated. Thanks!