var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: access to mysql data migration
I am trying to migrate some data from Access to Mysql via ODBC. I have successfully set up all of my datasources but the query to select from Access and insert into MySQL doesn't seem to be working:
INSERT INTO oem ( oemnumber, manufacturer, description )
VALUES (select [STOCK].[PARTNO], [STOCK].[MANU], [STOCK].[DESC] from stock);
When I try and save the query it errors (syntax error in query expresion 'select [stock.partno]')- can anyone help at all??