Need to send Access data to specific Excel cells.... How?

[jdmartin8]

I have an application that collects data from a Palm handheld, and stores the data into an Access database table. I would like to have the data sent to an existing Excel file, and need to specify which data in the table goes to which cell in the Excel file. Furthermore, I would really like to have this happen invisible to the user, and perform automatically when the HotSync is completed on the handheld.

Am I dreaming, or can this actually be done? Thank you..

Jim D. Martin
Fort Wayne, IN

 

[judgehopkins]

jdmartin8, I recommend you buy and use Alison Balter's Mastering Access 2002 Desktop Development.

It has lots of info on sending stuff to Excel, including the answer to your question.

Judge Hopkins

http://www.psc.state.mo.us/adjudication.asp

There are only two rules for success: (1) Never tell everything you know.