I am able to extract the column names from the file into an array list. What to do next to create a table with these columns.
Secondly i have a data set taken from a file. All the data is initially string. Now i have to convert the ones corresponding to numeric to numeric real to real char to char n string to string respectively. This can done by analysing all the rows of the columns.
It can be done using the fact that real(string initially) will have a . followed by no.. But is there any other way or function defined to do so??
Loading
Vijaya KadiyalaPosted Feb 19, 2009, 11:54 AM
Do you want to create the table dynamically?? or based on your analysis you want to create the table first and load the data!!
Are you using Oracle or SQL Server??
Thanks
Vijaya Kadiyala
Http
://dotnetvj.blogspot.comMukul BudaniaPosted Dec 12, 2008, 2:16 AM
Mamta MPosted Dec 10, 2008, 3:54 AM
What format is the file present in? If it's an XML file, you can easily read its schema into a DataSet...but if it is text, then it might be difficult as there are no built-in classes for that.
-Mamta.