General discussion

Locked

Access/Excel data problems

By jvdewaard ·
Have an Access db, also have an Excel Workbook with several sheets. A particular sheet produces a quote/joborder. the db is supposed to supply the "qouteID" , supply the date of the quote, and store a copy of the quote. The Workbook figures out thecost of each item and the pricing of the overall quote.
NOW the question, how do i get single cell information from the worksheet to and from the db? DDE confuses me, ADO doesn't seem to work for me( maybe it just me), macros are easy enough, however don't know enough about them either.

Would really like to link from the db to an ACTIVE sheet in excel and have the data saved in both apps on closing.... any ideas?
THanks

This conversation is currently closed to new comments.

1 total post (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Back to Software Forum
1 total post (Page 1 of 1)  

Related Discussions

Related Forums