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-06-13 : 07:29:59
|
| Hi I've a text file that i want to import into a SQL table but the text file has no Delimiters has any1 ever come across this before ?. |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-06-13 : 08:12:51
|
If all the rows are the same length then it is probably a file with fixed length data columns.So you will have to find out from the supplier of the file - what the layout is - and then do some coding around it.If I was you though I would insist on a delimmited file - just makes things so much easier.Duane.  |
 |
|
|
rookie_sql
Constraint Violating Yak Guru
443 Posts |
Posted - 2006-06-13 : 11:19:58
|
| I got the file this afternoon and it worked fine, their seem to be a tab between them. |
|
|
|
|
|
|
Text file with no Delimiters