Solved

Access and Google Drive

Posted on 2014-10-31
2
187 Views
Last Modified: 2014-11-06
I am using the following code to import XML files into an Access table:

    Set fd = Application.FileDialog(msoFileDialogFilePicker)
    With fd
        .InitialFileName = "c:\sample\*.xml"
        If .Show = -1 Then
            For Each vrtSelectedItem In .SelectedItems
                Application.ImportXML _
                    DataSource:=vrtSelectedItem, _
                    ImportOptions:=acStructureAndData
             Next vrtSelectedItem
        Else
        End If
    End With
    Set fd = Nothing

Open in new window


This has been working perfectly.  But now instead of having the user navigate to a folder location on their computer which is what the above code does, they need to somehow navigate to a location on Google Drive.  

Can this even be done and if so has anyone done it before?

--Steve
0
Comment
Question by:SteveL13
2 Comments
 
LVL 9

Expert Comment

by:bas2754
Comment Utility
Just a shot in the dark, but do they have the Google drive synching to their local computer, if so you should be able to just change the path.  If you need to pull directly via the Web, I am not sure you will be able to do that with the basic version and someone more advanced than myself will need to point you to where to find the code for the API to do it.
0
 
LVL 84

Accepted Solution

by:
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 500 total points
Comment Utility
I believe you can "map" the Google drive to be a local drive (like you'd map a network drive, for instance). If you can do that, your code should work as is.
0

Featured Post

6 Surprising Benefits of Threat Intelligence

All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

Join & Write a Comment

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

771 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now