MySQL Forums
Forum List  »  MySQL for Excel

Excel to MySQL
Posted by: richard briggs
Date: June 11, 2012 07:42AM

Hi,

I don't have an MySQL install, but am hoping to find someone who could find a little spare time and test/confirm an application I am coding 'Excel to Database'.

You can find the application here:
Excel to Database

I need some help as I am not a MySQL user and am unable to test with MySQL, so I have tried to guess the correct entries for MySQL.

In particular the application has a support file 'SQL-Flavours.XL-DB.xml'.

Within the file are settings for different database types, including MySQL.

This snippet shows the definition for SQL server (with which I am familiar) followed the definition for MySQL:

<SQLFlavour>
  <Code>MSSQL</Code> 
  <Name>Microsoft SQL Server</Name> 
  <DBMSName>Microsoft SQL Server</DBMSName> 
  <StoredProcMethod>SCRIPT</StoredProcMethod> 
- <ExecProcFormat>
- <![CDATA[ DECLARE @ReturnCode int;[br]EXEC @ReturnCode = {proc_name}[br]|sp_params|@{param_name}={param_value}|end_sp_params|;[br]IF @ReturnCode <> 0 RAISERROR('Procedure failed',16,1)[br]
  ]]> 
  </ExecProcFormat>
- <InsertFormat>
- <![CDATA[ INSERT INTO {table_name}[br]([br]{fields_csv}[br])[br] VALUES[br] ({values_csv})
  ]]> 
  </InsertFormat>
  <FieldNameQualifierStart>[</FieldNameQualifierStart> 
  <FieldNameQualifierEnd>]</FieldNameQualifierEnd> 
  <ItemQualifierEnd>]</ItemQualifierEnd> 
- <GetProcCode>
- <![CDATA[ sp_helptext {proc_name}
  ]]> 
  </GetProcCode>
- <GetTableDefinitionCode>
- <![CDATA[ sp_help {table_name}
  ]]> 
  </GetTableDefinitionCode>
  <StringDelimeter>'</StringDelimeter> 
  <Notes /> 
  </SQLFlavour>
- <SQLFlavour>
  <Code>MYSQL</Code> 
  <Name>MySQL</Name> 
  <DBMSName>MySQL</DBMSName> 
  <StoredProcMethod>SCRIPT</StoredProcMethod> 
- <ExecProcFormat>
- <![CDATA[ CALL {proc_name} (|sp_params|@{param_name} := {param_value}|end_sp_params|)
  ]]> 
  </ExecProcFormat>
- <InsertFormat>
- <![CDATA[ INSERT INTO {table_name}[br]([br]{fields_csv}[br])[br] VALUES[br] ({values_csv})
  ]]> 
  </InsertFormat>
  <FieldNameQualifierStart>`</FieldNameQualifierStart> 
  <FieldNameQualifierEnd>`</FieldNameQualifierEnd> 
- <GetProcCode>
- <![CDATA[ SHOW CREATE PROCEDURE {proc_name}
  ]]> 
  </GetProcCode>
- <GetTableDefinitionCode>
- <![CDATA[ describe {table_name}
  ]]> 
  </GetTableDefinitionCode>
  <StringDelimeter>`</StringDelimeter> 
  <Notes /> 
  </SQLFlavour>

If anyone with some MySQL experience can help I would be very grateful.

Best regards
Richard



Edited 1 time(s). Last edit at 06/11/2012 07:44AM by richard briggs.

Options: ReplyQuote


Subject
Views
Written By
Posted
Excel to MySQL
3469
June 11, 2012 07:42AM
1281
June 11, 2012 07:50AM
1371
June 11, 2012 06:10PM
1399
June 12, 2012 01:35AM
1262
June 12, 2012 06:09AM
1323
June 13, 2012 02:02AM
1212
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.