How to Push Data from Excel into Access?

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Reading SQLServer Data Base into Excel 4
Getting information from access table in excel 1
Pulling Access data into Excel 6
Access #Error & Excel Pivot 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
How do I limit the rows returned into Excel from a query 1
Run Existing Access Query From Excel 6
Running MS Access From Excel VBA: Communication Between Processes? 2

Top