In reply to Chris Hemedinger.

"you can write your own code that uses DBMS=EXCEL"

Great - how do you do that? I need to be able to import and export data to individual sheets in Excel and to multiple tables in MS_ACCESS and I have yet to discover any way to do that. Ideally in code, so I don't have an insane process flow diagram.

Thanks!