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

  • Thread starter Thread starter arni
  • Start date Start date
A

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 :]
 
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
message news: said:
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 :]
Click to expand...
.
Click to expand...
 
Back
Top