Excel userform export to access table

[DannyJ]

Hi All,

I have been trying to do this for a while now Any help would be much appreciated. I have a userform with combo boxes and text boxes and when submit is clicked it exports the data to a seperate excel spreadsheet. I would also like the data to be exported to an access table that I have set up with all the same field names. I have found the following code but it is for direct spreadsheet to access which obviously doesn't work. Any help is greatly appreciated.

I have attached the code as my firewall won't allow me to put it in the body of this message.

Thanks in advance,

Danny

[DannyJ]

I have decided to do this through the worksheet now. I thought I had it working but it isn't actually exporting the data even though it is running through the whole code without any errors.

I have attached a workbook with the code in VBA.

Thanks in advance.

[DannyJ]

Anyone that can help with this? I have the access table linked to excel at the moment but would prefer it if the userform could export direct to access due to the way it is at the moment meaning that I can't edit the data from the access side.