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??

Many thanks

Chris Moore