"Real-time" update of Access table from Excel spreedsheet

[Mortalous]

Hello all. I have a little problem that I need to get resolved. Basically I have an excel spreedsheet that users enter data on. I want to be able to have them enter a value into a cell then hit the neter key or click a button and from that, it appends an Access table with the date and time of the entry along with the data. Also, once they enter this data want it to append to the table and clear the cells out again. Currently, I have everything completed except for the linking I spoke of above. I was told that I can use DDE to accomplish this but I truly have noe experience with coding DDE or VB for that matter. Is there an easy way to do this? Anyone have an resources that can help me do this on my own? Please offer an advise you may have. Thank you all . .

 

[TonyU]

[tt]check with the gurus at VBA, they're good with this sort of stuff.

[tt]
^{"The only ideas that will work for you are the ones you put to work."}
[/tt]

​

 

[MichaelRed]

Or generate a simple Ms. Access FORM for the data entry and 'trash' the excel thing.

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[TonyU]

or if you know ASP....
I could help you.

[tt]
^{"The only ideas that will work for you are the ones you put to work."}
[/tt]

​