I've got a workbook that needs data from multiple tables within a widely used Access file on our network. The authors "helpfully" put the file in a folder path of "X:\Data Tables 3.0\data"
Because of the dot in 3.0, I can't do a normal Query of the file (KB Article ID: 214377). I'm getting around the limitation by temporarily copying the file to my C: drive and then doing the Query to that location. Thats fine for me, but I want others in my dept. to be use the workbook as well.
Anyone know how to automate the copy of the Access file from within Excel using VB? What about deletion after I'm done with the copy? Doable?
Or is there a different way to obtain the data from the Access file directly without running into the error?
Thanks in advance,
Kestrel
---------
The difference between Theory and Practice is that, in Theory they are the same. In Practice, they aren't.
Given the lack of responses, I'm going to assume the answer is No.
Not really suprised, as I could see some security issues in manipulating non-excel files via VBA.
Thanks anyway to those who looked at it.
---------
The difference between Theory and Practice is that, in Theory they are the same. In Practice, they aren't.
In VBA
But maybe you can copy the file into a networkfolderSub alternative() filecopy "X:\Data Tables 3.0\data\example.mdb", "C:\test.mdb" End Sub
Thanks snb, I'll give it a shot tonight.
---------
The difference between Theory and Practice is that, in Theory they are the same. In Practice, they aren't.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks