G
Guest
Greetings, thank you in advance for any assistance you can provide. What I
am trying to accomplish is the import of specific cells in an excel
worksheet. There are two parts of the worksheet, the first is contact
information, the second is a list of products.
The cells for the contact information is static, there will be 7 fields.
The product information will have 3 fields but there may be 1 row up to
65,500 rows. I need to somehow accomplish this import with the click of a
button.
I can create the button and access the VBA, what I am hoping is that someone
has the meat of the code that I can just alter to suit my needs. If you
want/need more specifics about the excel worksheet and the database let me
know and I can provide that.
Thank you again for any assistance you may have. Any good references would
also be appreciated. -John
am trying to accomplish is the import of specific cells in an excel
worksheet. There are two parts of the worksheet, the first is contact
information, the second is a list of products.
The cells for the contact information is static, there will be 7 fields.
The product information will have 3 fields but there may be 1 row up to
65,500 rows. I need to somehow accomplish this import with the click of a
button.
I can create the button and access the VBA, what I am hoping is that someone
has the meat of the code that I can just alter to suit my needs. If you
want/need more specifics about the excel worksheet and the database let me
know and I can provide that.
Thank you again for any assistance you may have. Any good references would
also be appreciated. -John