-
Hallo
Dim myAccess As Access.Application
Set myAccess = New Access.Application
myAccess.OpenCurrentDatabase "c:\!dev\VB-World\db1.mdb"
myAccess.DoCmd.TransferSpreadsheet acImport, 8, "Imported Book", "c:\!dev\VB-World\book1.xls", True
myAccess.CloseCurrentDatabase
Set myAccess = Nothing
Please tell me if I'm mistaken, but you will need Access on the PC where this piece of code should run?! Why I'm asking is that the code will run on thin-clients where Access is not loaded. I heard that there are certain runtime files (dll's ect.) that can be registered so that you do not need the Access package, but still invoke an instance (application) with the code above. Can someone either tell me what files do I need or some other way to work around this Access problem.
Thanx for the help...I need it desperately.
-
You need the Access executable available. there is a run-time module available with the Office Developer's Toolkit. Check out "Access" on Microsoft's site.
Cheers,
Paul.
