Showing posts with label arno. Show all posts
Showing posts with label arno. Show all posts

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