Hello,

I have an access database with around 150 tables.

Each table represents an electricity meter recording usage every 15 minutes

Each table has 2 columns,

column 1 = Date & Time (increasing from top to bottom in 15 minutes increments)
column 2 = Meter reading

These tables are very long and can contain 2 years worth of data or approx 70,000 rows. Each day 96 more rows are added to the bottom of the table representing the last 24 hour period.

I need to automatically transfer this database into excel so that i can manipulte the data and create automatic reports that people can view. Can anyone tell me how to automatically convert the whole database to and excel workbook, or some other way of automatically setting the transfer up?

Thanks a million,
Jimmycooker.