Andy Davies wrote:
Hi,
after years of moaning about users inadvertantly updating tables I actually
want to have an excel worksheet that is linked to backend (SQL Server)
data update the backend.
This seems it ought to be easy (there is already an oledb (ado?) connection
(in the Query Tables collection) but I can't find out how to access it or
bind cell data to fields
Has anyone done this?
thanks
Andrew Davies MBCS CITP
- AndyD 8-)#
I *think* you can do it by embedding the XLS in a general field as a
linked file, then when they open it (or you do it for them) you get the
Excel interface.
Does that help?
Matthew S. Jarvis
IT Manager
Bike Friday - "Performance that Packs."
www.bikefriday.com
541/687-0487 x140
[EMAIL PROTECTED]
_______________________________________________
Post Messages to: [email protected]
Subscription Maintenance: http://leafe.com/mailman/listinfo/profox
OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech
** All postings, unless explicitly stated otherwise, are the opinions of the
author, and do not constitute legal or medical advice. This statement is added
to the messages for those lawyers who are too stupid to see the obvious.
