Write data to MySql

[elias41]

Hi,

I would like to write data to a MySQl workbench table without destroying its structure.

I tried the following:

Code: Select all

wfsave(type=odbc) dsn=MYDSN;uid=USERNAME;pwd=PASSWORD;database=MYDATABASE "insert into estimates (field1, field2) values ('",date,"',",value,")"

However, this fills the whole table and changes field data types.

Is there a controlled way (preferably in SQL like an insert) to insert values into a MySQL database besides the workaround in http://forums.eviews.com/viewtopic.php?f=3&t=29. If not I fear to have imlpement it in form of the suggested workaround :(

[EViews Gareth]

Unfortunately not.