i have a txt file with the following data which i took from eventlog.
" TimeCreated : 4/25/2011 7:58:59 AM ProviderName : jobrun Id : 990 Message : THIS IS IT "
Like this i have more than 100 rows. Now i have requirement of loading this data into the database with the columns timecreated, providername, id, message. Can anyone please help in loading this data from the txt file.