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

Mahenbasu gravatar 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

Kev Riley gravatar image

Kev Riley ♦♦
53.8k 47 49 76

(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][1]

[1]: http://support.microsoft.com/kb/321686
more ▼

answered May 26, 2011 at 03:39 AM

Pavel Pawlowski gravatar image

Pavel Pawlowski
22.3k 9 11 21

(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

megamanblue gravatar image

megamanblue
310 6 6 8

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

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:

x476
x116
x18

asked: May 26, 2011 at 03:32 AM

Seen: 1028 times

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