
March 10th, 2004, 02:55 PM
|
|
Registered User
|
|
Join Date: Mar 2004
Posts: 2
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
URGENT:HELP REQD in importing text file
I have a delimited text file (*.txt) that I need to import into a SQL database. The column delimiter is the ^ symbol and the carriage line feed is | symbol. When I use the Import data utility in SQL and import the text file, I see that the data isn't input into the table in an orderly way, that is: though the data in the text file is perfectly in order with regard to carriage line feed and column delimiter, the lines in the SQL table are disorganized and jumbled. Am I doing something wrong? Is there a way by which I can get the text file to get input in order? Thanks.
Ana
|