FORMAT ISSUE WHILE IMPORTING FROM EXCEL TO SQL USING DTS
-
hI
When i m importing data from excel to Sql using DTS the column which has text content was not imported as same in excel sheet. whereas a special character is appearing in between the lines. the text field contains multiple lines but the conetent is imported in single line .
ex:
ARIZONA
ALABAMA
STATE
but i m getting imported
as :
ARIZONA ALABAMA STATE
How to Format a single column while importing?
-
Are you mentioning any delimiters in moving data.
Cheers,
Sugeshkumar Rajendran
SQL Server MVP
http://sugeshkr.blogspot.com -
Yeah. Row Delimiter as {CR}{LF} and Cloumn delimiter as Tab.
while trying without delimiter also the special character is coming. all the lines were coming in a single line.
-
Hi Can Any one help,
I am new to this forum, so not sure if its the write place to post a question.
Well i got a flat file (in{CR}{LF} format) and needs to be imported into a sql server 2000.
now i need to know how can i create a package using DTS or some thing which kindoff breaks the data down and insert it into appropriate tables from the flat file. I need to find a way to carry it out in one process as the data is imported through the pipe. SO i have multiple tables which would eventaully contain the data from flat file after two weeks. is there any way i can automate the process.
regards
-
After the data is imported, how are you veiwing it to see it as "ARIZONA ALABAMA STATE "??
If you're looking at it in Enterprise Manager, or the Query Analyzer grid view, then the data won't wrap over multiple lines.
Use Query Analyzer with the "Results to Text" and see if the data wraps over multiple lines. This will comfirm that the multiple lines from the Excel cell have been transferred into the field.
--------------------
Colt 45 - the original point and click interface
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply