Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Multiple Delimiters

Status
Not open for further replies.
Jenns

Jenns

Programmer
Nov 1, 2000
36
US
Hi!

Has anyone every had to import a text file into SQL Server that has more than one delimiter? I have a text file delimited with pipes and commas; however the import wizard only allows me one column delimiter. Can I get around this?



Thanks!
Jenn
 
Sort by date Sort by votes
Edit your text file and substitute the pipes for commas.

Thanks

J. Kusch
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Palooka
  • Locked
  • Question
How to *easily* import multiple DTS packages? 1
Replies
3
Views
184
MDXer
MDXer
runner15
  • Locked
  • Question
Running DTS multiple times looping VB
Replies
2
Views
155
runner15
runner15
budgetboy
  • Locked
  • Question
Import Multiple Excel Spreadsheets into an SQL table
Replies
1
Views
106
rodeomount
rodeomount
rodeomount
  • Locked
  • Question
Possible to select multiple fields in a Lookup?
Replies
1
Views
113
fuzzyocelot
fuzzyocelot
klewis10367
  • Locked
  • Question
Combining Multiple DataBases
Replies
0
Views
68
klewis10367
klewis10367

Part and Inventory Search

Sponsor

Back
Top