Excel Form into Access Database

Hi Guys

I need to find a way of exporting data from forms made in Excel, into a simple Access Database.

The Excel forms contain certain information such as First Name, Surname, Age etc and the user enters the information into cells which are not in a nice simple list, the cells containing the information i need can be odd (C7, D8, C6, J4, J11 etc - the sheet looks like a user form)

Is there a macro i can assign to a button i keep on the toolbar in Excel that will in effect copy and paste the information from these cells into a row in Access? The reason i mention a button on the title bar is that the filenames of the excel sheets will vary and so i was hoping to keep the macro in Personal.xls rather than send out new forms with a macro built in???

Hope that makes sense?

try this link

http://databases.about.com/od/tutori...eltoaccess.htm


may help

Nice one thanks bud