• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 253
  • Last Modified:

IMPORT COLUMN DATA FROM WORD TO SQL 2005



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
judsonmusic
Asked:
judsonmusic
1 Solution
 
kenpemCommented:
Have a play with DTS.
0
 
judsonmusicAuthor Commented:
and what is DTS???
0
 
Anthony PerkinsCommented:
Data Transformation Services.  Look it up in Books Online.
0
 
pinaldaveCommented:
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

Become an Android App Developer

Ready to kick start your career in 2018? Learn how to build an Android app in January’s Course of the Month and open the door to new opportunities.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now