tag:blogger.com,1999:blog-14479009.post6840571083186650061..comments2023-11-24T12:30:17.358+01:00Comments on Ronald Lemmen - CRM, C# and Cme: Import CSV file to DataTableRonald Lemmenhttp://www.blogger.com/profile/11930631598114156863noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-14479009.post-53199687444054451942014-07-05T07:23:09.417+02:002014-07-05T07:23:09.417+02:00We can use to import a .csv file to DataTable by u...We can use to import a .csv file to DataTable by using this line of code<br /><br />DataTable dt=new DataTable("C:\test.csv");<br />after this we can read lines of this data table by using DataReader.Anonymoushttps://www.blogger.com/profile/11008068317022048697noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-54167519888735515642012-04-03T10:27:10.035+02:002012-04-03T10:27:10.035+02:00Thank you! quick and helpful :)
KerenThank you! quick and helpful :)<br />Kerenkerenhttps://www.blogger.com/profile/16002309498213964389noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-61344866767061776372009-05-05T17:27:00.000+02:002009-05-05T17:27:00.000+02:00Thanks so much! This is a sweeet way to handle cs...Thanks so much! This is a sweeet way to handle csv files. God bless you.igjuananoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-12022478441704968682008-12-12T20:25:00.000+01:002008-12-12T20:25:00.000+01:00VERY handy! Thanks!!VERY handy! Thanks!!Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-61275488955674593362008-09-23T06:50:00.000+02:002008-09-23T06:50:00.000+02:00This is a nice once. However, I have a problem wi...This is a nice once. However, I have a problem with it. How do I set the type of data retrieved? For example, I have a field with data 0123456789, and when retrieved, the 0 (zero) is missing. I assume it automatically converts to number format? What should I do?<BR/><BR/>Thanks.Unknownhttps://www.blogger.com/profile/14182448372631938834noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-89614533110896285432008-07-17T09:33:00.000+02:002008-07-17T09:33:00.000+02:00Hi Matthias,This piece of code does only load the ...Hi Matthias,<BR/><BR/>This piece of code does only load the data into a datatable in memory. From memory you would need to copy the data to crm. That is another approach for data migration compared to the data migration framework. You should think carefully about which approach you will be using when migrating data. Depending on how many entities, related data, multiple sources etc you should Ronald Lemmenhttps://www.blogger.com/profile/11930631598114156863noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-68969172070837697432008-07-16T20:04:00.000+02:002008-07-16T20:04:00.000+02:00This indeed looks very powerful. Do you think thi...This indeed looks very powerful. Do you think this type of code could replace the Data Migration tool? Or does that tool do stuff behind the scenes like run stored procs, code that you don't see?maatthiashttps://www.blogger.com/profile/01990109409539208785noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-27582401492519143162008-06-16T19:39:00.000+02:002008-06-16T19:39:00.000+02:00Do you know a way to do this if the CSV "file" is ...Do you know a way to do this if the CSV "file" is already in a string variable?mkamoskihttps://www.blogger.com/profile/09534434189588567205noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-73034301197134276622008-05-15T15:55:00.000+02:002008-05-15T15:55:00.000+02:00Man, this is genius!! In knew there was something...Man, this is genius!! In knew there was something behind the Excel Magic and now i can use it's raw power<BR/><BR/>Thanks for posting it man :¬)Tim Hustlerhttps://www.blogger.com/profile/09876620056216675947noreply@blogger.comtag:blogger.com,1999:blog-14479009.post-70832295862905451232008-04-11T04:25:00.000+02:002008-04-11T04:25:00.000+02:00ping back from http://www.castorsoft.com/articles/...ping back from http://www.castorsoft.com/articles/2008.3.10.htmAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-14479009.post-19328449279787626142008-03-31T12:57:00.000+02:002008-03-31T12:57:00.000+02:00Hi! This is Nice Blog! Data Conver...Hi!<BR/> This is Nice Blog! <BR/> <A HREF="http://www.e-datapro.net/" REL="nofollow">Data Conversion Services</A> provides all Convert Raw Data into MS Office.Conversion from Page maker to PDF format.Conversion from Word to HTML format.Conversion from Text to Word Perfect.Conversion from Text to Word to HTML and Acrobat Fine.Anonymousnoreply@blogger.com