Update Excel from MS Access

Update Excel from MS Access

Before I found Bob’s excellent code on the BTAB Development Web Site… (To see it Click The Button Below) … I relied on the two links from Microsoft which you can find below.

One link demonstrates the automation method to transfer data cell by cell, which is fine for small amount of data. For lots of data, use the CopyFromRecordset method as it is more efficient.

Update Excel ADO

Update Excel from MS Access

Image 1

Someone asked:- How to update Excel from MS Access? (Access World Forums) 

This question reminded me that I had a couple of excellent links hidden away, a couple of links to Microsoft Support where they provide two excellent articles on how to do this. I thought I would share the links with you!

Methods for transferring data to Excel from Visual Basic

How to transfer data from an ADO Recordset to Excel with automation

Image 1

… …

More Useful Stuff HERE:-

Leave a comment

This website uses third-party software - WordPress Add-Ins to be exact. I don't know what any individual add-in does, but I'm sure that many of them collect information about you. So be aware, if you continue using this site, then you are likely to be sharing your information. I don't know how to disable this sharing for any, or all of the plugins for individual users. So I can't stop the sharing of information. If this worries you then please do not use this site... If you continue to use this site I will assume that you are happy with it.

Do you need a hand in the right direction?

You are in the right place.