QB said:
I need to create an update query to pass records from an Access table to a
MySQL table, but when I am in the query designer and select the Append Query
it request the destination table and the ODBC table does not appear??? It is
there when I go to the Tables Object browser. What is going on? How can I
do this?
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
First, find out if you can access the MySQL table:
1. Open the query's SQL View.
2. Type in something like this:
SELECT TOP 2 * FROM MySQL_table_name
Substitute the MySQL table name for 'MySQL_table_name.'
3. Run the above query.
If you get any results then you can use the SQL View to create the
Append (INSERT INTO) query. Syntax:
INSERT INTO MySQL_table_name (column_name1, column_name2, ...)
VALUES ('aaa', 'bbb', 222, ....)
If you're using a SELECT use this syntax:
INSERT INTO MySQL_table_name (column_name1, column_name2, ...)
SELECT col1, col2, ...
FROM source_table
WHERE <criteria>
HTH,
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)
** Respond only to this newsgroup. I DO NOT respond to emails **
-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv
iQA/AwUBShzsKoechKqOuFEgEQIg1QCffzSZj1EeZNTMXoXmJIT+68kIPwQAn2Jx
lnml40BOay9IXEJ0WJAQsLuw
=dOFc
-----END PGP SIGNATURE-----