Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-08 : 10:17:49
|
| Malik writes "I have a text format and I would like to convert it to an SQL format.The text is not 100% organized. There is a little difference between the entries in the each text file.I want to be able to make queries from which I can list the results as I wish." |
|
|
davidpardoe
Constraint Violating Yak Guru
324 Posts |
Posted - 2002-01-08 : 11:14:07
|
| I think we are going to need a little more detail.DTS can be used to import text files but you do need to provide information concerning the layout of the file.Alternatives are BULK INSERT and BCP. These require a little SQL knowledge - DTS has some wizards?Tell us more about the data you want to import and how much you know about SQL Server.============The Dabbler! |
 |
|
|
|
|
|
How to convert ASCII text ito Sql