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 |
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
 Posted - 2006-07-21 : 04:46:52
|
| I've a .txt file with no delimiters or column names that i want to import into a database,so far i've tried everything but nothing works ? anyone any ideas |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2006-07-21 : 05:28:18
|
You can use DTS to import using fixed length column size.Or import the text file into a table with single col and process accordingly using left(), substring() or right()
KH |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-07-21 : 06:03:12
|
| I think i will have to use your point no2 Or import the text file into a table with single col and process accordingly using left(), substring() or right()Could you give me a example of how i would go about doing this thanks |
|
|
|
|
|
|
File with no delimiters or column names