Sunday, February 19, 2012

EXcel sheet into database with stored procedure

Hi,

What is the syntax of storing the content of an Excelsheet in a predefined
table
with a stored prcedure.

Arno de Jong, The Netherlands.A.M. de Jong (arnojo@.wxs.nl) writes:
> What is the syntax of storing the content of an Excelsheet in a predefined
> table
> with a stored prcedure.

As I don't use Excel much with SQL Server, I went to http://www.google.com
and entered:

Excel INSERT "SQL Server"

and god a couple of hits. The first one is a blog entry from SQL Server
MVP Dejan Sarka:
http://solidqualitylearning.com/blo.../03/12/441.aspx.

This should get you started.

--
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pr...oads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodin...ions/books.mspx

No comments:

Post a Comment