Help regarding importing data from the excel sheet to mysql

[eklavyavats]

I am able to import data from the database to excel sheet. But i was unable to load the data from the excel sheet to my sql.I have connected the excel sheet to my sql but the data that is imported to the database is corrupted as it is required to enter how the two data are seperated and how does the new line begins. I will b using the visual basic for this purpose. Can i get any sort of help

[code green]

It is not clear how you are writing to and from the DB. Or if you are doing it programmaticall y. 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.

[eklavyavats]

It is not clear how you are writing to and from the DB. Or if you are doing it programmaticall y. 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.itt oolbox.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.microso ft.com/default.aspx?sc id=kb;en-us;306572

[eklavyavats]

It is not clear how you are writing to and from the DB. Or if you are doing it programmaticall y. 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've found out some s/f'wares. You can use them to connect excel sheet to mqsql. Or you can make sql database by using them.

These are the links:

Some important links regarding connecting excel sheet to mysql

http://www.surfpack.com/software/importexceltomysql/

http://www.surfpack.com/downloads/dir/MySQL-Migration-Toolkit-13277-download.html

http://www.vclcomponen ts.com

http://www.stardeveloper.com/articles/display.html?article=2003101901&page=1

[code green]

I thought you wanted to write it yourself in VB. These are off the shelf software applications.

[eklavyavats]

I thought you wanted to write it yourself in VB. These are off the shelf software applications.

I've got some links 2 for writin a program.....


http://www.aspfree.com/c/a/ASP.NET-Code/Read-Excel-files-from-ASPNET/

http://support.microso ft.com/default.aspx?sc id=kb;en-us;306572

[code green]

Inserting .xls files in to a database has been a problem of mine for a while. I have had to convert them in Excel to a .csv first. Although you started the thread you have pointed me towards a possible solution. If you are going to develop some code I would be very interested

[eklavyavats]

Inserting .xls files in to a database has been a problem of mine for a while. I have had to convert them in Excel to a .csv first. Although you started the thread you have pointed me towards a possible solution. If you are going to develop some code I would be very interested

i am working on the code and if i can work it out i will def tell u... n thanks a lot for your help.....