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 <--
--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L
"Samuel" <stwi...@writeme.com> wrote in message
news:1180531159.7...@q66g2000hsg.googlegroups.com...
or automate it with a macro : sendobject
automatically outputs your table to excel according to your settings
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
Very helpfull, thank you all.