x

Placing data from XLsheet into data table using sql server 2000

Hi,

How to place data from XLSheet into data table using sql server 2000

more ▼

asked May 26, 2011 at 03:32 AM in Default

avatar image

Mahenbasu
11 1 1 1

(comments are locked)
10|1200 characters needed characters left

3 answers: sort voted first

There are a number of ways to do this

  • DTS package

  • Import wizard from Enterprise Manager (right click on the database node, if I recall)

more ▼

answered May 26, 2011 at 03:36 AM

avatar image

Kev Riley ♦♦
63.8k 48 61 81

(comments are locked)
10|1200 characters needed characters left

You can use eg. the Data Transformation Services or eg. OPENROWSET command.

You can take a look on MSDN: How to import data from Excel to SQL Server

more ▼

answered May 26, 2011 at 03:39 AM

avatar image

Pavel Pawlowski
22.7k 10 15 26

(comments are locked)
10|1200 characters needed characters left

If you are going through enterprise manager, right-click the database you want to import the data to and then scroll to All tasks -> Import data. Follow the instructions in the dialog box suppling the correct information. Make sure you have you Excel sheet closed though otherwise DTS will not be able to read it (That caught me out for a long time, long ago :D)

more ▼

answered May 26, 2011 at 07:14 AM

avatar image

megamanblue
310 7 6 11

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x501
x140
x21

asked: May 26, 2011 at 03:32 AM

Seen: 1192 times

Last Updated: May 26, 2011 at 03:37 AM

Copyright 2016 Redgate Software. Privacy Policy