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 |
AskSQLTeam
Ask SQLTeam Question
0 Posts |
Posted - 2005-06-15 : 07:58:56
|
Gary writes "I am consistantly given a .txt file with thousands of numbers. I use these numbers in a query, and have to go through each line inserting a comma after each number. As you can imagine, I don't necessarily 'dig' this process, and would like to refer to the txt file from within the query without having to modify the information. I've had some friends tell me how to do this through writing a seperate application, but can't this be done through using just a query?Gary Vickery" |
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-15 : 08:11:56
|
How do you know where one number starts and another ends so you can put in the comma?JimUsers <> Logic |
|
|
JimL
SQL Slinging Yak Ranger
1537 Posts |
Posted - 2005-06-15 : 08:40:37
|
My Guess is these these are tab seperated.Use bulk insert to drop the .txt into a SQL table then query that table.JimUsers <> Logic |
|
|
|
|
|