pass through query from access to Mysql

[doddo]

Hi, i'm trying to run a pass through query that appends a table in my SQL db from an access 95 table on a client.

Please could you tell me why I get the following syntax error?

insert into Ph_ABP.Member_ID
select Member_ID from c:\Windows\Desktop\db1.ABP

I have the MyODBC set up correctly as far as i am aware as it lets me pull tables down into access using the 'select' command

any help appreciated,
cheers

 

[robert22]

You cannot do this because you are trying to select from a table that does not belong to mysql at all. This is a mysql command regarding mysql tables from mysql databases.
I think that you should read the documentation about the 6.4.8 LOAD DATA INFILE Syntax. This should help you get the data in the mysql database quickly. I have tried other methods and I could not find another one as fast as this one.

Let me know if it helped, ok!