Access to Excel

N

Neil Greenough

I have a table in a form in a DB which contains different information, ie
price, units etc... Now, what i'd like to do is transfer the info from the
DB into an Excel invoice using a code. So, basically in my table I have a
button, whereby when I click on it, my Excel template opens and information
is copied over from certain fields in Access to certain cells in Excel.

Is this possible? and if so how?
 
V

Van T. Dinh

You probably need to use Automation to fill the Excel
template with data from Access.

Check Access Help or Access books on automation. There
are some article also on the Microsoft Web site but I
don't have the links handy.

HTH
Van T. Dinh
MVP (Access)
 
A

Arvin Meyer

Neil Greenough said:
I have a table in a form in a DB which contains different information, ie
price, units etc... Now, what i'd like to do is transfer the info from the
DB into an Excel invoice using a code. So, basically in my table I have a
button, whereby when I click on it, my Excel template opens and information
is copied over from certain fields in Access to certain cells in Excel.

Is this possible? and if so how?
Click to expand...

Here's some sample code:

http://www.mvps.org/access/modules/mdl0006.htm

There's more at this site too, so have a look around.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
K

Ken Snell

And if you need more help after reviewing all the resources provided, post
back. I've done work using ACCESS to write to EXCEL.
 
Top