export access database to excel file

[Yama12]

hi
first i connect to an access file as database then i get some query like this sql code and save it to a new table:

SELECT * FROM TABLE INTO SMS

now in want to save the result in an excel file instead of SMS table....
but how??

[Tolls]

Comma separated file?
After all, you have given us no info at all about the format for your excel file.

[Yama12]

in past in ms-access file ,i right clicked on the table and used export as Excel file
in this way i have a excel file exactly same as my access file
i want

[Tolls]

Is it an Excel file or a CSV?

If it's a CSV then write a CSV as a file (possibly using the Apache CSV library).

If it's an Excel file then you'll need to read up on something like Apache POI.

[Yama12]

its excel
read up on something like apachi???!!!! i dont know what are u exactly talking about!!!
i have found this sql syntax in somewhere

SELECT * INTO [Excel 8.0;Database= c:\\1.xls].[sheet1]

[Tolls]

That's Access SQL, so you'd want an Access forum to find out about that.

Apache POI.

Or, possibly, Open CSV, which might be easier.