.csv file to dataset

[jack]

Hi all,
Im thinking a way ahead.
can any one help tell me whether it is possible to convery a cvs
file into dataset and then save into the database directly..

Thank for replying me...

 

[Guest]

Hi all,
Im thinking a way ahead.
can any one help tell me whether it is possible to convery a cvs
file into dataset and then save into the database directly..

Yes, you can use Microsoft's Text Driver to query a text file into a
Dataset.

Otherwise, you can just manually build a Dataset (i.e. loop through the
CSV0

 

[sloan]

See my blog at:
http://spaces.msn.com/sholliday/

Specifically, the
9/22/2005 article.



Leveraging XP Excel , Xml, and OPENXML for Data Imports