Updating Table with Excel

[wtrimble]

Hello all,

I have uploaded my co workers data from Excel into an Access table. However my co worker constantly updates that table in Excel after each testing she does. I ran a macro originally: "transfer spreadsheet" to transfer the excel data to an access table but my problem is that whenever she updates her excel file and uses the macro, it will add on and duplicate the whole spreadsheet to the Access table, whereas we just need it to update it.

I can't figure out how to have Access recognize duplicates and only add on new information. I'm not familiar with coding...(I'm new to Access) so is there way I can do this with macros...??

Thanks for any help on this

 

[Zaeed]

You could link to the excel file so that access treats it like a table.. That way whenever the excel file is modified the database is also..

 

[wiklendt]

why not just ask her politely to use the database instead?

 

[dbDamo]

Exactly wiklendt. What is the point using Excel for data entry but access for storage?

Obviously you won't want her to enter the data directly into the table, so just design her a nice form which should make data entry much simpler for her and make the switch from Excel to Access more beneficial to her.

 

[wtrimble]

I would but she needs to enter vasts amount of information and her machine will only output to Excel! bummer

 

[wtrimble]

How do you link an Excel table with an Access table??

 

[wtrimble]

Nevermind! Figured it out. Exactly what I needed to do.
Thanks Zaeed