excel to access

H

horton123

`hi all,

i was wondering about having a userform from excel with its data
feeding into an access table. Is that possible? I expect the answer is
yes but......

at present my userform enters simply into a spreadsheet behind it

i.e textbox1 = a1 etc.

I have unfortunately cant attach my current workbook but if you email
at [email protected] i will send it to you and if anyone can
tell me how this can be done i would be most appreciative

I have specified the current code below aswell if that helps.
I have really only used access back in my uni days so i need some help
here!

If anyone can help me, i have a spare google acccount or two going!
(gmail).
thanks in advance

steve

Worksheets("Sheet4").Range("b13").Value = combobox1_input
Worksheets("Sheet4").Range("b14").Value = combobox2_input
Worksheets("Sheet4").Range("b15").Value = LocalAccount1.Text
Worksheets("Sheet4").Range("b16").Value = Description1.Text
Unload Me
Sheets("Sheet4").Select
 
Top