Need VBA Code To Get The Data From Google Drive Excel Sheet

[Ashfaque]

Hi,

I am looking for vba code lines to import data from a Google Drive Online Recruitment (Protected Excel sheet - I have userid and pwd) to local Excel in pc or direct to Access tbl and then clean the Online Recruitment Excel Sheet (at web) so that next time when I connect web Excel again there will be new data.

Further I can manage to transfer data from local access tbl to required dept head in a specific format.

Regards,

 

[Ranman256]

1 method is :
to manually download the file to the same place everytime, say: c:\temp\File2Import.xls
then run queries to process data in access..

Note: the file c:\temp\File2Import.xls is linked as an external table.
This need only be done once.

(Tho someone else may have a way to read directly from the google drive.)

 

[Ashfaque]

1 method is :
to manually download the file to the same place everytime, say: c:\temp\File2Import.xls
then run queries to process data in access..

Note: the file c:\temp\File2Import.xls is linked as an external table.
This need only be done once.

(Tho someone else may have a way to read directly from the google drive.)

Thanks Runman256,

This may helpful to me for post 50% of work but I need the code to connect Excel sheet on Google Drive and read

I need vba code or some ideas to read google drive excel file and store in local Access tbl.

Any other Idea?

 

[arnelgp]

a further step, there is a VBA to actually write the "records" of google sheet to
a local excel file (excel vba):

How to import data from Google Sheets into Excel with VBA

I am trying to import data from Google Sheets into Excel but I think the problem is with the security settings in my computer. Already tried to create a new query > from other sources > from web and

stackoverflow.com

you need to research the rest.

EDIT:
just test it on my google sheet and it successfully import it.

 

[Gasman]

Perhaps start here?

 

[Minty]

Unless you can map the location of the target file in code, I suspect you may struggle with this.
Access doesn't understand a shared web-based folder, but it will understand a mapped drive.

There are very similar issues with Sharepoint or One-Drive file storage.

 

[pekajo]

Hi,
See
'Onedrive/Google drive Hosting'

Onedrive/Google drive Hosting.

Hi, I have been playing around with MS Access during lockdown (Victoria Australia) and have just discovered that you can set your Onedrive and Google drive to also be hosting. What this then give you is from Access you can directly export what you like to your Local drive and then use a...

www.access-programmers.co.uk

on this forum.

on this forum
Peter