importing excel into access

[Jbliss503]

Good Morning,

I am wondering if it is possible to import an excel worksheet into access to partially update records in a table. I know how to import worksheets to either create a table or create new records within a table; however, I have, as of yet, not been able to figure out how to update existing records with the given method... or if it's even possible for that matter. Any help would be greatly appreciated.

Thank you in advance
Jeremy

 

[boblarson]

Import the spreadsheet to a transitional table and then use append queries and update queries to send the data to the proper location.

 

[Jbliss503]

man... what a simple solution. Thank you for the insight, works like a charm!

 

[boblarson]

man... what a simple solution. Thank you for the insight, works like a charm!

No problem, glad we could help.