MySQL Forums
Forum List  »  MySQL for Excel

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

Options: ReplyQuote


Subject
Views
Written By
Posted
2198
October 29, 2012 11:30AM
Re: Insert Data in Table from Excel sheet
1799
December 04, 2012 07:50AM


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.