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

How to Push Data from Excel into Access?
 

http://erlandsendata.no/english/index.php?t=envbadac

Hth,
Merjet

How to Push Data from Excel into Access?
 

Thanks Merjet

Interesting link

S

"merjet" wrote:

http://erlandsendata.no/english/index.php?t=envbadac

Hth,
Merjet