Access To Excel and Back to Access

[ColinKJ]

Hi All,

Can anyone help me with some example code that extracts data from an Acces table, then when changed in Excel, an example of code to write the data from Excel back to Access.

Any assistance would be much appriciated.

 

[Joe4]

Please note rule 10 here: http://www.mrexcel.com/forum/showthread.php?t=99490

You are allowed to cross-post here, but we ask that you indicate that you have cross-posted and provide links to each thread in the other. I update your other thread. Here is the link for this one here:
http://www.mrexcel.com/forum/showthread.php?t=566753

Regarding your question, there have been numerous threads here over the years about updating data between Access and Excel (you should be able to find some by searching the forums). But the first question I would ask is, is it really necessary? Is it possible to do it all in Access instead, and avoid Excel altogether?

 

[ColinKJ]

Hi Joe4,

My apologies for the cross post I wasn’t aware of the need to note the cross post.
<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
Joe, as I think you know from an earlier thread, I'm new to Access, but have done a lot of VAB work in Excel.
<o></o>
You are probably correct about doing it all in Access, but at present I'm experimenting.
<o></o>
I really would be grateful for some example codes.<o></o>
<o></o>
<o></o>

 

[Joe4]

If you search on "Update Access Excel" and limit your search to just the thread titles, you will see lots of threads on the topic.

Here are a few to get you started, you will see a lot more if you do that search yourself.
http://www.mrexcel.com/forum/showthread.php?t=490236
http://www.mrexcel.com/forum/showthread.php?t=354325
http://www.mrexcel.com/forum/showthread.php?t=51157