"Fortuno, Adam" <[EMAIL PROTECTED]> wrote: > Yo gang! Having a problem with the MySQL ODBC 3.51 driver. > > I've got a MySQL volume which has a user table (tbl_usr). I'm linking this > table to an Access database on my workstation (via ODBC link). The account > being used for the connection has select, update, and insert rights to all > tables in the database. > > I'm populating the linked (MySQL) table with data I've got on my workstation > in an MS Access database. To do this, I'm simply executing an "insert into > ... select ... from" statement. > > INSERT INTO tbl_usr (fst_nm, lst_nm, tle_nm, email_addr) > SELECT tbl_stage.First, tbl_stage.Last, tbl_stage.Title, > tbl_stage.Email > FROM tbl_stage; > > However, each time I execute the statement I receive an error (see attached > file - mysql_odbc_err.pdf). The error message provided isn't very helpful. > Can anyone elaborate?
Could you show error message as a plain text? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
