copy excel data into an access database

[cutsygurl]

I am a real novice in VB so if anyone can help me even alittle it would be awesome. I have a userform in excel that will be filled out and inputed into a sheet in table fomat in the same file. I have a access database with a table that matches the fields in the excel file. Since many people will be filling out the same form i need a way to input that data, by pressing a button, into an access database and a way to update the record if the data has been changed. I have been looking at books and at the web and nothing is helping me.

Thanks in advance.

[oldchippy]

Take a look at this link it may help

http://articles.techrepublic.com.com...1-5276622.html

[ST4RCUTTER]

cutsygurl,

How are your users going to interact with this data? Through Excel? Through Access? Or both? You can easily link Access to an Excel sheet. Whenever changes are made to the Excel sheet it automatically updates the table in Access. This is fine as long as you don't have multiple users needing to access the Excel sheet simultaneously and as long as you don't exceed 65,536 rows of data.

If these two rules are going to be broken then I would build everything in access and create a front-end with forms to the table so users can enter data right onto the table. You can also create append macros that will import an .xls, .csv, or even .txt files to an existing table.

What will work best for the users?

[cutsygurl]

There are going to be mulitple excel files that will connect with one access database. The excel file with a userform will be send out in an email for others to fill out and sent back to me to be inputed into a database.