output access data directly to excel?

[Samuel]

Is it possible to export table data directly in to an excel format? I
can cut and paste it, but I would prefer to automate the output
process.... Any suggestions greatly appreciated!
Samuel

 

[Stefan Hoffmann]

hi Samuel,

Is it possible to export table data directly in to an excel format? I
can cut and paste it, but I would prefer to automate the output
process.... Any suggestions greatly appreciated!
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 <--

 

[Roger Carlson]

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.

--
--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

 

[Guest]

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

 

[Guest]

Check File-Export

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

 

[Michelle Meyer]

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

 

[Guest]

Cool Michelle, thanks

 

[Samuel]

Cool Michelle, thanks
--
Jeff C
Live Well .. Be Happy In All You Do










- Show quoted text -

Very helpfull, thank you all.