hi Samuel,

You can use Jet in a query to export data to a new file:

  SELECT *
  INTO [Excel 8.0;Database=YourPath/File.xls].[SheetName]
  FROM table

Or you use

  DoCmd.TransferSpreadSheet

in VBA.

mfG
--> stefan <--

Look into the TransferSpreadsheet method.  On my website
(www.rogersaccesslibrary.com), is a small Access database sample called
"ExportToExcel.mdb" which illustrates one way to use this.

Using the save as function you can save data that is open in excel format,
export in excel format etc.

Check File-Export

or automate it with a macro : sendobject
automatically outputs your table to excel according to your settings

Hello Samuel:

There is a button for your tool bar which allows you to send data directly
to Excel or Access. However, the button has to be added to your toolbar. The
following steps will help you add the needed button to your toolbar.

1. Right-click on your toolbar.
2. Select "Customize" from the pop-up menu.
3. When the "Customize" dialog box opens, choose the "Commands" tab.
4. In the left-hand "categories" window scroll down till you find "tools".
Select the "Tools" category. You will see different "Commands" appear in the
right-hand window.
5. The very first command in the right-hand window should be "Office Links".
If not scroll down in the "commands" window until you find "Office Links".
6. Once you've found the "Office Links" command, click-drag-&-drop it onto
your toolbar.
7. Close up the "Customize" dialog box and you'll have the "Office Links"
button on your toolbar.
_______________________________________

1. The office links tool allows you to send data directly to Excel or Word.
There are three different options. All of the options are displayed when you
click the down arrow on the right-hand side of the button.

Hope this helps:

Michelle