export a table to google sheet

[Rashid]

i have a ms access db i want to auto export a table to googlesheet or sharepoint when I update the table. Because of protecting the important data. so is there any vba code to do this. thanks in advance.

 

[theDBguy]

Would RunCommand acCmdExportSharePointList work? Or maybe the TransferDatabase method?

DoCmd.TransferDatabase method (Access)

Access VBA reference

learn.microsoft.com

 

[Rashid]

I want to explore the complete table sir.

 

[GPGeorge]

I want to explore the complete table sir.

"Explore". How does exporting data to an external file help you explore it?

 

[Gasman]

Perhaps Google and see how it is done for Excel and modify to suit?

upload to google sheet vba - Google Search

 

[Rashid]

"Explore". How does exporting data to an external file help you explore it?

sorry sir it is export not explore

 

[Gasman]

Tony,
Seems using Google Forms is quite simple as well?
Plenty of videos on YouTube, some with code as well.