Dumb Question. I need to move my data from their current access database to my new MySQL server through an ODBC connection. The tables on both ends are set up identially. I have added a linked table to the access database called EXPARTAB1. The data is in EXPARTAB. I tried: INSERT INTO EXPARTAB1 VALUES (SELECT * FROM EXPARTAB)That should be:
insert into EXPARTAB1 select * from EXPARTAB
or maybe you should do something like:
insert into destination_tablename ( field_1, field_2 ) select field_1, field_2 from source_tablename
You'll have to do it the 2nd way if you change any field names.
This is the most reliable way to shift data from one database to the other ( via Access ).
You can use scripts, but you have to rely on the author of the script setting the data types correctly.
Setup your tables yourself, making sure all your destination fields can accommodate your data, and the make a set of queries in Access ( access calls them 'append queries' ). If there is a problem, Access will usually let you know where it occured so you can go and fix it.
-- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
