Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

output access data directly to excel?

0 views
Skip to first unread message

Samuel

unread,
May 30, 2007, 9:19:19 AM5/30/07
to
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

unread,
May 30, 2007, 9:27:40 AM5/30/07
to
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 <--

Roger Carlson

unread,
May 30, 2007, 9:29:03 AM5/30/07
to
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


"Samuel" <stwi...@writeme.com> wrote in message
news:1180531159.7...@q66g2000hsg.googlegroups.com...

Ben

unread,
May 30, 2007, 9:34:00 AM5/30/07
to
Check File-Export

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

Jeff C

unread,
May 30, 2007, 9:33:02 AM5/30/07
to
Using the save as function you can save data that is open in excel format,
export in excel format etc.
--
Jeff C
Live Well .. Be Happy In All You Do

Michelle Meyer

unread,
May 30, 2007, 10:53:48 AM5/30/07
to
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


Jeff C

unread,
May 30, 2007, 1:02:00 PM5/30/07
to
Cool Michelle, thanks

--
Jeff C
Live Well .. Be Happy In All You Do

Samuel

unread,
May 31, 2007, 1:48:25 PM5/31/07
to
> > Michelle- Hide quoted text -
>
> - Show quoted text -

Very helpfull, thank you all.

0 new messages