Access Database Homepage

Question: How do i convert an access database to sql server express r2 when the access program's trial period is up?

(Posted by: mallan on 2010-07-17 22:43:35)

I have a 2007 Access database but cannot do hardly anything with it as most buttons are blanked. The trial period has finished for Access. How can I convert it to an Sql SDerver Express R2 database?

Posted by: TheMadProfessor on 2010-07-19, 08:44:18

You could try simply opening the Access mdb (or better still, a copy of it, jic) in SQL Server - since they are both Microsoft products (and SQL Server is more advanced), it might be able to convert it for you automatically. If not, try to export it from Access (if you can do so from an expired version) into a CSV or XML file and then import into SQL Server.