I think if I used this method, given what i'm trying to do with the document i.e. split fields and other things this should give me more control.

Okay so I'm presuming the ODBC driver is the software it needs to actually perform the functions in the code? I'm still having problems running the code successfullly as it tells me there's no default driver set or installed.

Is it due to a line of code I can remove to get this to work?