MySQL Forums
Forum List  »  MySQL for Excel

Re: Excel to MySQL
Posted by: richard briggs
Date: June 11, 2012 06:10PM


Tested with MySQL and so far so good!

Test 1 : Excel to MySQL table
I had a couple of problems:
1/ I had the wrong string terminator ` instead of '

2/ Transactions!
This is why I wanted to ask the MySQL experts .. the Excel to database utility uses transactions to test that the row data is valid, then rolls the transaction back.

I found however that the transaction would not roll back. After some digging I discovered MySQL tables must be created with a flag TYPE=InnoDB;

After correcting my test table, all went well.

3/ If data contains apostrophes(') then the utility fails the row database validation (row colour amber):

Please can you tell me the best way to handle this in MySQL Syntax?

Test 2 : Excel to MySQL Stored Procedure
I will let you know how I get on with testing this .. I may need some help ..

Excel to MySQL


Edited 1 time(s). Last edit at 06/15/2012 03:43PM by richard briggs.

Options: ReplyQuote

Written By
June 11, 2012 07:42AM
June 11, 2012 07:50AM
Re: Excel to MySQL
June 11, 2012 06:10PM
June 12, 2012 01:35AM
June 12, 2012 06:09AM
June 13, 2012 02:02AM
October 11, 2012 03:36AM

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.