Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to Push Data from Excel into Access?
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to push data to another cell | Excel Worksheet Functions | |||
Importing data from Access to Excel, but I need to vary the table from Access | Excel Programming | |||
Push/write data into an unopened file | Excel Worksheet Functions | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Using MS Query to Push Data to Oracle | Excel Programming |