Interaction with google sheets

[eatraas]

Hi,

i've searching the web and this forum for a clear answer but i haven't found it yet.
I want to be able go get data from an access databse into a google sheet format.
The other way around is out there and works just fine, but from access to google sheet puzzles me.

Who can point me in the right direction?

Regards and tnaks in advance.

Erwin

 

[Uncle Gizmo]

I've been exploring the possibility of doing this for quite a while.

Bruce McPherson has written lots of code for shifting data between Excel and Google sheets and vice a versa. I would suggest you have a look at his blog here:-

http://ramblings.mcpher.com

Also ridders (Colin) a member of this forum has written code for shifting data around with Json, I think you will need to use something like that. So it might be an idea if you searched Colin's threads and have a look at some of the examples he has provided.

Sent from my SM-G925F using Tapatalk

 

[CJ_London]

I want to be able go get data from an access databse into a google sheet format.

If I've read your requirement correctly it sounds like a question more appropriate to a google sheets forum to pull data from access. google sheets does not use vba. This link would appear to provide what you want

https://developers.google.com/apps-script/guides/jdbc

As you say, plenty of examples out there to push data from access to google sheets

 

[nardimrk]

interesting