MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro posting Excel data to Access database...


Posted by Bill Tanner on May 11, 2000 1:15 PM

I am looking for some code that will allow me to automatically post some information from Excel to Access.

I will need to:

~ open the database ("database")
~ create a new record
~ post data from Sheet 1, Cell A1 to field A in the database
~ close the database.

Later, I will need to:

~ open the database ("database")
~ find an existing record
~ post data from Sheet 1, Cell A2 to field B in that record
~ close the database.

Can anybody help?

Thanks much

Bill Tanner


Posted by Ivan Moala on May 12, 2000 12:09 AM



Bill rather then explain the whole lot
I'll send you and anyone else who needs it
a help file. This should get you under way.
Look under Access.
Enjoy


Ivan

Posted by Bill Tanner on May 12, 2000 2:36 PM

Note to self... Hire it done!

Thank you for the help, Ivan. I can tell from a quick review that it is beyond me and I think I'll go and hire it done...

Bill Tanner