Quote:
Originally Posted by code green
It is not clear how you are writing to and from the DB. Or if you are doing it programmatically. And by Excel do you mean XLS? MySql has problems with XLS (At least I do).But CSV files are uncorrupted so long as the CSV fields go in the same order as the DB table.
I was trying to take data from the excel sheet to the database. And yes, Excel sheet means .xls. I have done the job if i would have been using .csv format. Actually in .csv format we can specify that how the data and the new line are seperated but in xls i dont know how they both are seperated i.e. the records and the lines. If we can find a way to distinguish them then the job would be done as i have imported the data but was not able to distinguish between the seperators.
anyways i was just looking out for something and came upto some links which i am just about to read.
Try them out.
http://visualbasic.ittoolbox.com/groups/technical-functional/visualbasic-l/importing-data-from-excel-sheet-into-sql-435980
http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/
http://support.microsoft.com/default.aspx?scid=kb;en-us;306572
