I'm trying to populate a simple Excel worksheet from data within MS Access, setup as an ODBC datasource. I've looked up some sample code and every piece of code I've seen has a reference to the absolute path of the .mdb file. Is there a way to simply access the datasource the way ODBC *should* work, or is this yet another of Microsoft's added "features"? The code I've looked at involves the use of ADO to create a connection. I've got the code, I just don't want to have to reference the path of the Access file directly as this has security implications for the data I need to gain access to.
All help gratefully received!!!
All help gratefully received!!!