473,386 Members | 1,969 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

importing data with CR-LF

I have a coma del text file that has an email that has to go into a
varchar(4000) . This email column has CR-LP and coma as part of the
text. when I try to import the table, i am getting a truncation error
and it reject the next line thinking its the next row.
How can I import column with CR-LF characters ?

thanks

roger

Aug 8 '07 #1
1 2417
On Aug 8, 3:51 pm, Roger <wondering...@gmail.comwrote:
I have a coma del text file that has an email that has to go into a
varchar(4000) . This email column has CR-LP and coma as part of the
text. when I try to import the table, i am getting a truncation error
and it reject the next line thinking its the next row.
How can I import column with CR-LF characters ?

thanks

roger
I usually encapsulate text within a character that doesnt occur inside
data, like * or even ? and
use the MODIFIED BY CHARDEL& to specify the string delimiter
character. It works...

Aug 8 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Stephen Saunders | last post by:
Hey Folks, This one currently has me stumped. I have to check for the existence of a carriage return (Enter key, hex 0D) in text data. First I tried: 'Check comment to not contain the CR...
11
by: Grim Reaper | last post by:
I am importing a .csv file into Access that has 37 fields. My problem is that sometimes the last field only has data at the end of the column (it looks like when you import a file into Access, for...
7
by: Darren | last post by:
I have been attempting to create a reservation planning form in excel that imports Data from an Access database and inserts that information automaticly into the correct spreed sheet and the...
6
by: beowulfs | last post by:
Here's what I've got: I've got a form with combo boxes. you can select already existing company names or type in new ones. if you type in a new one, it prompts you to double click the combo...
7
by: Timothy Shih | last post by:
Hi, I am trying to figure out how to use unmanaged code using P/Invoke. I wrote a simple function which takes in 2 buffers (one a byte buffer, one a char buffer) and copies the contents of the byte...
2
by: sureshgv | last post by:
SqlConnection cn=new SqlConnection ("User ID=sa;Initial Catalog=usermodule;Data Source=NEW5"); SqlDataAdapter da=new SqlDataAdapter (Application.ToString(),cn); DataSet ds=new DataSet();...
12
by: JMO | last post by:
I can import a csv file with no problem. I can also add columns to the datagrid upon import. I want to be able to start importing at the 3rd row. This will pick up the headers necessary for the...
6
by: mfoolb | last post by:
Hi, I need to import lot of data from html files (all the same layout and tables name) to a MySQL db. Is there any class that fullfill my needs? What's the fastest way to accomplish that? ...
8
by: Brock | last post by:
I am trying to populate a Crystal Report from data in my DataGrid. The reason for this is that I want the user to be able to change values without updating the database, but still have their report...
4
by: =?Utf-8?B?Z2lkZHk=?= | last post by:
hi, I posted here earlier with a great reply:...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.