Solved

IMPORT COLUMN DATA FROM WORD TO SQL 2005

Posted on 2006-11-11
4
246 Views
Last Modified: 2012-08-14


I have a column of 50 rows of sentences that I want to cut and paste into SQL table and have it auto number them and such,

Is there anywa yto copy and paste a table or column from Excel?????????

Judson
0
Comment
Question by:judsonmusic
4 Comments
 
LVL 4

Expert Comment

by:kenpem
ID: 17922976
Have a play with DTS.
0
 
LVL 3

Author Comment

by:judsonmusic
ID: 17923214
and what is DTS???
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 17923324
Data Transformation Services.  Look it up in Books Online.
0
 
LVL 21

Accepted Solution

by:
pinaldave earned 500 total points
ID: 17923385
Hello,
Following may help:
---
How to import data from Excel to SQL Server
http://support.microsoft.com/kb/321686
---
Explains in detail how to use DTS:
http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=135&rl=1
---
If you are looking for some utility:
SQL*XL
Linking MS Excel to databases
http://www.oraxcel.com/projects/sqlxl/

Regards,
---Pinal
0

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Join & Write a Comment

Introduced in Microsoft SQL Server 2005, the Copy Database Wizard (http://msdn.microsoft.com/en-us/library/ms188664.aspx) is useful in copying databases and associated objects between SQL instances; therefore, it is a good migration and upgrade tool…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

705 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now