IMPORT COLUMN DATA FROM WORD TO SQL 2005

judsonmusic
judsonmusic used Ask the Experts™
on


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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Have a play with DTS.

Author

Commented:
and what is DTS???
Top Expert 2012

Commented:
Data Transformation Services.  Look it up in Books Online.
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial