Does anyone know of some downloadable software or an online facility to convert Access databases to SQL and SQL databases to Access.
I am not looking for a "why dont you just use one type", I am merely looking for the straight forward answe please
I believe you can export an access database to a text file. And then use it to import in an sql database. I've only done this once a long time ago so I'm certain of the exact steps.
Maybe you can find answers on this page also? http://www.microsoft.com/sql/techinfo/deployment/70/accessmigration.asp