C#

public class TextToDataSet
//created by ashish gupta on 12/5/2005 for log register
	{
		public TextToDataSet()
		{
			//
			// TODO: Add constructor logic here
			//
		}

		public static DataSet Convert(string File, 
			string TableName, string delimiter)
		{   
			//The DataSet to Return
			DataSet result = new DataSet();
    
			//Open the file in a stream reader.
			StreamReader s = new StreamReader(File);
        
			//Split the first line into the columns       
			string[] columns = s.ReadLine().Split(delimiter.ToCharArray());
  
			//Add the new DataTable to the RecordSet
			result.Tables.Add(TableName);
    
			//Cycle the colums, adding those that don't exist yet 
			//and sequencing the one that do.
			foreach(string col in columns)
			{
				bool added = false;
				string next = "";
				int i = 0;
				while(!added)        
				{
					//Build the column name and remove any unwanted characters.
					string columnname = col + next;
					columnname = columnname.Replace("#","");
					columnname = columnname.Replace("'","");
					columnname = columnname.Replace("&","");
        
					//See if the column already exists
					if(!result.Tables[TableName].Columns.Contains(columnname))
					{
						//if it doesn't then we add it here and mark it as added
						result.Tables[TableName].Columns.Add(columnname);
						added = true;
					}
					else
					{
						//if it did exist then we increment the sequencer and try again.
						i++;  
						next = "_" + i.ToString();
					}         
				}
			}
    
			//Read the rest of the data in the file.        
			string AllData = s.ReadToEnd();
    
			//Split off each row at the Carriage Return/Line Feed
			//Default line ending in most windows exports.  
			//You may have to edit this to match your particular file.
			//This will work for Excel, Access, etc. default exports.
			string[] rows = AllData.Split("\r\n".ToCharArray());
 
			//Now add each row to the DataSet        
			foreach(string r in rows)
			{
				//Split the row at the delimiter.
				string[] items = r.Split(delimiter.ToCharArray());
      
				//Add the item
				result.Tables[TableName].Rows.Add(items);  
			}
    
			//Return the imported data.        
			return result;
		}
	}

leelaraj wrote:

CDate isnot a recognised function name

leelaraj wrote:

how to cnvert Mod 60 in to sql server

skyeddie wrote:

my EXCEL DATABASE