HOW TO SAVE 3 TABLES (AS A SHEET NAMES) IN ONE 1 EXCEL FILE IN ACCESS

[arni]

Please advise how to output different tables in one excel
file? The output should be saves in one excel file but
will have different sheet names based on the table names.
For example, the database have A, B, and C tables. I
would like to saved these into 1 excel file having 3
sheets namely A, B and C.

Please advise how to do this either in access or excel?
Could anyone give me a sample code?

many tanx,

arni :]

 

[arni]

onedaywhen,

many thanks ...

:]

-----Original Message-----
Use queries e.g.

SELECT *
INTO [Excel 8.0;Database=C:\NewFile.xls].[A]
FROM A

SELECT *
INTO [Excel 8.0;Database=C:\NewFile.xls].
FROM B

etc

"arni" <[email protected]> wrote in

Please advise how to output different tables in one excel
file? The output should be saves in one excel file but
will have different sheet names based on the table names.
For example, the database have A, B, and C tables. I
would like to saved these into 1 excel file having 3
sheets namely A, B and C.

Please advise how to do this either in access or excel?
Could anyone give me a sample code?

many tanx,

arni :]

.