MySQL Forums
Forum List  »  MySQL for Excel

Advanced Search
New Topic

Re: Insert Data in Table from Excel sheet
Posted by: samm 22
Date: December 04, 2012 07:50AM

Hi

If you are using sql server then you can easily insert data from excel file to table by using import export utility. Choose your excel file as datasource and your database table as destination. Then map column of table with your excel colum.

After that import you data..

Check out the link

http://support.microsoft.com/kb/321686


Hope its help

Thanks
www.myniagaratours.com

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
Insert Data in Table from Excel sheet
2264
TA GHA
October 29, 2012 11:30AM
Re: Insert Data in Table from Excel sheet
1428
Philip Olson
October 30, 2012 07:39PM
Re: Insert Data in Table from Excel sheet
1276
Devart Team
October 31, 2012 02:52AM
Re: Insert Data in Table from Excel sheet
1420
ergi veseli
November 09, 2012 11:01AM
Re: Insert Data in Table from Excel sheet
1832
samm 22
December 04, 2012 07:50AM
Re: Insert Data in Table from CSV File - Error 1064
1435
Andrew Lietzow
January 01, 2013 10:02AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.