Web Software Architecture and Engineering – Life on the Bleeding Edge

MSSQLTips.com points out an interesting capability of Excel 2003+, that solves a problem for many developers who generate Excel reports for business users. Once those reports are updated, developers usually end up processing the Excel, in one fashion or another, to update databases if need be. This solutions lets SQL Server talk directly to Excel. Looks interesting and dangerous!
Read more @ http://www.mssqltips.com/tip.asp?tip=1540.

Advertisements

Comments on: "Inserting, Updating or Deleting Data in SQL Server from an Excel Spreadsheet" (1)

  1. Great work! This is the kind of info that are meant to be shared across the net. Shame on Google for not positioning this post higher! Come on over and consult with my web site . Thanks =)

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: