How can I pull a field from a record in access into an excel she.

G

Guest

I am trying to pull specific information from an access database into certain
specific cells in an excel sheet. For instance, an employee fills out an
access form with date and time, etc. and this info is then exported to an
excel file that displays all of the info in a coversheet for his/her report.
The coversheets are currently being filled out by hand, and I am trying to
create an easy system of drop down menus to save time, etc.
 
G

Guest

hi,
it might be easier to go about it the other way around.
have they fill out the form. instead of export for access,
import in into excel from the excel side. then use a excel
macro to populate the coversheets.
 
J

John Nurick

Hi Doug,

On Sat, 29 Jan 2005 20:39:01 -0800, Doug Wiklund <Doug
I am trying to pull specific information from an access database into certain
specific cells in an excel sheet. For instance, an employee fills out an
access form with date and time, etc. and this info is then exported to an
excel file that displays all of the info in a coversheet for his/her report.
The coversheets are currently being filled out by hand, and I am trying to
create an easy system of drop down menus to save time, etc.

Here are some useful links:

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Methods for Transferring Data to Excel from Visual Basic (most of this
applies to Access VBA too)
http://support.microsoft.com/default.aspx?scid=kb;en-us;247412

Using Automation to Create and Manipulate an Excel Workbook (Q210148)
http://support.microsoft.com/?id=210148

Run Excel macros through Automation
http://www.mvps.org/access/modules/mdl0007.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top