Mixing database types

<i><b>Originally posted by : Jerry Scannell (JScannell1@home.com)</b></i><br /><br />I would like to open a connection to an Access database and a dBase database file at the same time. The reason? I wish to export all or part of a an Access table to dBase for use by a DOS-based program that can manipulate dBase files.<br /><br />What I have been doing up until now is creating a text file consisting of the contents of the Access table and then executing the .exe which appends the text file to the .DBF file.<br /><br />This isn't very scalable, though. When I change the structure a little bit it requires me to change the .exe too.<br /><br />In a nut shell, I would like to do the following:<br />FOR THE ACCESS TABLE<br />Set AccessConns = Server.CreateObject("ADODB.connection")<br /> AccessConns.Open "DSN=Access Driver Name;"<br /><br />I then need a similar set of objects pertaining to a dBase IV table. I produced an ODBC DSN for dBase IV but nothing I try seems to work and I can't find any documentation on how to do this. Anyone know how?<br />