Query to migrate to MySQL 1

[doorbreaker]

Hi,

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

 

[DonQuichote]

The query you gave contains two separate syntaxes together. It is either:

INSERT INTO <table>(<field list>) VALUES (<value list>);

or:

INSERT INTO <table>[(<field list>)] SELECT <field list> FROM <table>);

The first one is used for "hardcoded" values, the second for values that are looked up from another database or table.

Best regards

 

[doorbreaker]

Thanks Don, that works.