Access to Excel

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

 

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

 

[Kailash Kalyani]

Here's the link to an MSDN article:
http://support.microsoft.com/?kbid=210288

Hope this helps,
Kailash Kalyani,
Developer Support Engineer
ITWorx on behalf of Microsoft EMEA GTSC

 

[Arvin Meyer]

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?

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

 

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