Hi!

I'm creating a report in Excel. The report is derived from several thousands
rows of data (typically 40-50.000). The data comes from 2 different
databases (Oracle and SQL-server).

I would like to set up an Access db for temporary data storage. With the
data in the same db I can create a recordset which joins the 2 tables.
Ideally the db is created (with two tables) every time the Excel-report is
executed, and thereafter removed (I could of course make it permanent but
the users have 15-20 other reports (all in Excel) and I don't want to
trouble them with an Access DB). I think that creating the DB from code
within Excel doesn't take to much extra time(?).

I need some example code for setting up the db with 2 tables. I don't know
if I need to set up the tables, perhaps I could just append the Excel
recordset, containing the data, directly to the db??

I run Excel 2000 and Access 2000.

TIA
PO