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 |
|
PurpleSun
Yak Posting Veteran
50 Posts |
 Posted - 2007-03-09 : 14:15:00
|
| Hi All,I need help with importing text file into a tableIt's a fixed-length file, which looks like this345981---02---01---SDE34---113745937---Smith-----James---01---Y748233---01---04---HRH83---284489324---Roberts---Alan-----01---Netc.Thanks, |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-03-09 : 16:46:59
|
| Enterprise Manager, right-click your database, All Tasks, Import Data...In the wizard, select Text File for your data source, you'll figure it out from there. |
 |
|
|
|
|
|
Import text file into SQL Server table