Cheers Roy.
One small problem. When I ahev the line: oConn.open after the oConn.connection.string, I get the error message "Operation is not allowed when the object is closed".
SO I moved the oConn.open line above the other line and the error message then read "Data source name not found and no default driver specified"
Seems like it can't run one line without the other first. Both ways.
Also, in the connection.string line, is the data source (c:\test.mdb in your example) meant to be the directory of the database into which I'm sending data?
Thanks for the help.
Mark