question

Mahenbasu avatar image
Mahenbasu asked

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
sql-server-2000excelimport
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

3 Answers

·
Kev Riley avatar image
Kev Riley answered
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)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image
Pavel Pawlowski answered
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
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

megamanblue avatar image
megamanblue answered
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)
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.