AIX

Generally, by paying someone to do so. Someone looking for automatic tools to convert computer languages is usually grasping at straws.

This is generally correct, but in detail one might experience problems. For instance: if i remember correctly Access treats undefined logical values as FALSE, standard SQL defines them as being "undefined". If your SQL query relies on this it might be syntactically correct but still not doing what it should.

I hope this helps.

bakunin

That is a good point, but this is precisely where the testing would come in. Since the OP will have renamed the original tables in the Access database, he can take several attempts at migrating the data. Plus in Access you can create functions that will translate undefined values to something else. I haven't done much Access lately but I thought that Access handled undefined data as an empty string rather than null. Either way testing will be important as well as migrating the data a number of times. But if this is your job, you have time to try it over and over until its right.