Linking multiple tables into a sheet for update

[Raeldor]

Hi All,

What is the best mechanism for attaching data from more than one table into
a spreadsheet so that the data can be refreshed and updated in the sheet and
sent back to the database? Ideally being able to setup formulas in the
fields that could be preserved on a refresh and sent on an update would be
ideal.

Thanks for any info.

Regards

 

[Peter Huang [MSFT]]

Hi Raeldor,

From your description, I understand you mean the Excel SpreadSheet.
For Excel application, there is a menu Data/Import External Data which will
retrieve the data from the Database.

But this is one-way operation, that is to say we can not push the change
back to the database, as Excel is a client side to present data but not
change data.

Anyway, we can make change back to the database via programming.

A simple way was to use VSTO which will utilize the ADO.NET technology.

Here is good start for VSTO programming for your reference.

Also we have a special newsgroup for VSTO.
microsoft.public.vsnet.vstools.office

If you still have any concern, please feel free to post here.

Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

 

[Peter Huang [MSFT]]

Hi Raeldor,

I am just checking to see how this is going.
Please drop me a quick note at your convenience to let me know the current
status of this issue.
If you have any concerns, please do not hesitate to let me know.
Thanks, and have a great day!

Best regards,

Peter Huang

Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.