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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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.
 
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.
Click to expand...

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