HighTechTalks DotNet Forums  

How to Read Hyphenated values from CSV File?

Dotnet Data Tools microsoft.public.dotnet.datatools


Discuss How to Read Hyphenated values from CSV File? in the Dotnet Data Tools forum.



Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old   
Antonio Tirado
 
Posts: n/a

Default How to Read Hyphenated values from CSV File? - 12-07-2005 , 01:36 PM






Hi,

I'm using the OleDB namespace to open a CSV File. I can read the file
sucessfully except for hyphenated values. My CSV File contains phone numbers
and sometimes these come separated with hyphens (ie: 555-123-4567). These
fields come as empty using the OleDB namespace and as dbNull when using the
ODBC namespace. Is there a way to prevent this from happening?

Thanks in advance,

Reply With Quote
Reply




Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.