Acces to Excel

[Dustin]

Is there any function or other way to have data in a cell
updated automatically from data in Access?

I have a scale program entering records into a table in
Access, and I need access to pass the data it recieves
along to excel as soon as it recieves it.

I'm running out of time, and I really need help on this.

Any helps greatly appreciated,

Dustin

 

[Ken Snell]

Update just one cell? You'd need to use Automation (in VBA code) to open the
EXCEL file, and write the value directly into the cell. Is this what you
want to do? Have you used Automation before? Post back with more info ...

 

[Guest]

Try going into Excel; go to your cell. Menu: Data_Get
External Data_New Database Query. Follow the wizard and
refer back to your database and insert it into the
desired cell in Excel.