Hello all. I have a little problem

[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 enter 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 I want it to append to the table and clear the cells out again. Currently, I have everything completed date and time stamp is automatically generated on the excel sheet) except for the linking I spoke of above. I was told that I can use DDE to accomplish this but I truly have no experience with coding DDE or VB for that matter. Is there an easy way to do this? Anyone have any resources that can help me do this on my own? Please offer an advise you may have. Thank you all . .

 

[remco5897]

I think the easiest way to approach this is to link the excell sheet to your dbase. This allows users to make changes in excell and since the excell sheet is linked to your dbase you can see those changes back into access.

To achieve this do the following:

In the dbase view do right-click and select link tables (make sure you select file type .xls).

Your excell sheet is now linked to your dbase. From this piont on you can start using macro's or code to do your appending.

Let me know if this helps.

Kind regards,

Remco