View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Grd Grd is offline
external usenet poster
 
Posts: 118
Default How to Push Data from Excel into Access?

Hi,

I'm contemplating a scenario and I'm not sure if this is the best approach.

I'm pulling data into Excel from Access using MSQuery. Making some
modifications to certain records. I would like to push these changes back to
Access.

MSQuery can't feed these excel changes back I'm guessing (?) so I'm thinking
that I will push the modified records back into a new table in access and
somehow merge the changes back into the original table perhaps through VBA.

I need some guidance with my approach. Is there an easy way of doing this?

Any help would be great

Thanks
Suzanne