Access Form to Excel sheet

K

KevinKBM

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

challa prabhu

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
 

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

Similar Threads

Integrating information from Word to Excel (not mail merge) 1
Shortcuts in OneDrive 0
Autonumber field in Excel that behaves the same as Access 0
adding words 1
Merging from an Excel file with graphics 1
access export to excel cell spacific 3
Crating User Form to Add Names 1
Excel does not accept text format! 0

Top