The question is not clear; you also did not specify what target database you would choose. If this is Microsoft SQL server, this is easier. One of the solutions is this:
http://support.microsoft.com/kb/237980[
^],
http://msdn.microsoft.com/en-us/library/ms140052.aspx[
^].
If you need something else, Google for database conversion.
Theoretically speaking, this is not a big problem. With .NET, you can use ADO.NET; read data from one database and populate another one. This is pretty hard to do in the general case, because for fully automatic processing you need to have the the
database schema, and the methods of retrieving of the schema are not universal. However, for Access this is not a problem. Please see:
http://social.msdn.microsoft.com/Forums/ar/vbgeneral/thread/5ccc3aac-3525-4241-902a-3d03a9169ae0[
^],
http://msdn.microsoft.com/en-us/library/kcax58fh.aspx[
^].
Also, if your source database is simple enough, you can program the conversion
ad-hoc, using your knowledge of the schema. The benefit is the possibility to improve the schema during conversion, for example, normalize the database.
—SA
Submit an article or tip