Access Form to Excel sheet
 

I can get access to send data to excel with no problem, what i need todo is
have the data from spacific fields in a access form be sent to spacific cells
in Excel.
for instance Customer name (CName) to C5 in excel. is there any way to do
this?

Access Form to Excel sheet
 

Hi,

You can wite a code in Excel, by connecnting to the approrpiate DSN, and
then fetch the filed and populate the value in a Excel sheet.

What is requird is the Workbook name and the cell location within the
apprpriate Sheet tab.

Challa Prabhu

"KevinKBM" wrote:

I can get access to send data to excel with no problem, what i need todo is
have the data from spacific fields in a access form be sent to spacific cells
in Excel.
for instance Customer name (CName) to C5 in excel. is there any way to do
this?