Hi Everyone:
I would like to have a command button on a form when pressed, it opens excel worksheets file - with data in it in MS-Excel and transfers the data into a ms-access table with the same fields names and data written in MS Access 2007 table. How do I write the VB code to a button in Access to perform this functionality. I need your help ASAP. Thanks.
I would like to have a command button on a form when pressed, it opens excel worksheets file - with data in it in MS-Excel and transfers the data into a ms-access table with the same fields names and data written in MS Access 2007 table. How do I write the VB code to a button in Access to perform this functionality. I need your help ASAP. Thanks.
