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 |
|
elwoos
Master Smack Fu Yak Hacker
2052 Posts |
 Posted - 2005-11-16 : 04:06:04
|
| I have a text file, approx 100 Mb that I will need to import once every few years or so. The data is fairly structured in the sense that records and fields are identified. The data looks (something) like this*RECORD* *FIELD* NO 100050 *FIELD* Another Field *RECORD* *FIELD* NO 100050 *FIELD* Yet Another Fieldetc. i.e. there is a marker at the start of a record and a marker at the start of a fieldFinally at the very end is *THEEND*Does anyone have any suggestions on the best way to import this? Do I need to learn BCP? I did wonder about making it look like XML by using FIND and REPLACE but I'm not sure what to do with it then to get it into my table.Thanks in advancesteve-----------Facts are meaningless. You could use facts to prove anything that's even remotely true! |
|
|
|
|
|
Multi Character delimiters