Re: Excel to MySQL

[richard briggs]

ok!

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

Thanks



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