Exporting to Excel

[eussias]

Here's my problem.... I have a number of tables in an Access 2000 db, all of which need to be exported to Excel, and merged into a single worksheet. The problem is that certain Clients can have more than one entry in certain tables, and only one in others. Does anyone know of the easiest way to export this all to Excel without constant cutting and pasting??

 

[Chopsaki]

You can use the Query tool under the data toolbar. If you cannot see this you may need to install it. You can connect to any data source using that. I would advise you put all your data into a nice query in access before using it.

 

[Chopsaki]

Or you can just connect using ado/dao and use the copyfromRecordset command to paste your records.