Save data From Excel Into Access

Hello Everyone.......

i am trying to write a macro, where in when i click a button (MACRO) the data that i have typed in excel should get saved in Access. i tried this macro..... the macro runs without any error, but there is nothing which gets executed..... can anyone help




======MACRO=====

Please Login or Register  to view this content.

I have saved the access Workbook as "Main.dbf"
and the table which the data has to be saved is "Company"
there are 5 columns to be saved....

the excel book where data is typed is "Experiment", and the worksheet is "Sheet1"


there is no error in the macro.... but there is no execution either....

PLEASE HELP

Sibalamit

I ran your code with a dummy workbook and database and it worked correctly. I have a couple of questions:
1 Why is your database .dbf? Access is usually .mdb.
2 Are you running the macro with the correct worksheet active?

Is your excel book protected at all? If you could post the workbook (minus any sensitive info) that might help.

Your code is opening main.mdb, not data.mdb...
Are you getting any errors, or are you getting blank rows added to your table, or something else?