export access database to excel file

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:

Code:

---

SELECT * FROM TABLE INTO SMS

---

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

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

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

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.

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]

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.