access table & excel

[nismo4me]

I am new to programming and have a question.

I have a userform with 3 comboboxes running a macro in excel and spitting out the data into a worksheet. What I would like to happen is the data that gets inputted into the worksheet after running the macro to be exported to a table in access forming new records. Is this possible? If so, how?

VBA code preferred

Thanks in advance

 

[nismo4me]

I added the excel applications to access's library and prompt the excel userform that way and just set the application screen to false so the workbook itself wasn't visible. Then I have TransferSpreadsheet pulling the data that I have the macro pulling into my table. All at the push of a button in access. Thanks for the help

 

[namliam]

No need to use the Excel applications library or to set it's visiblity to false....

TransferSpreadsheet is a Access thing that does not touch Excel directly !