[rcldave]

sorry, didn't realise the file hadn't attached – here it is again

[rcldave]

Hi Peter,

As requested, here's a copy of the original access structure…

Thanks

[rcldave]

Hi Peter,

Thanks for explaining the advanced option. I'll try that – it just isn't clear that the existing columnd definition is retained, but if that works that will be great.

Re the database definitions; I've uploaded the following files:

crm.sql is a dump of the empty database created by the application install. This is the one I want to add data to.

access.sql is a dump of the access database after I've imported it into a mysql database (I thought it would be easier for anyone to read instead of uploading the access db itself)

[rcldave]

No everything is different.

To try and explain more, I have a CRM application that uses a mysql database. I want to migrate the data from an existing in-house Microsoft Access database. The CRM includes many more tables and I'm trying to map the two as best I can.

For example, both systems have an amount of “contact” information, but the column definitions are different. I want to use the new definitions and populate the tables with some of the old data. Some columns are specific to the original Access database, so these won't be migrated across.

[Author]

Posts