Access to SQL Server 2005 Express

Report · Apr 07, 2009

Just been watching some info on the net about sql server express and I need some questions answered if possible...

Can I take an existing Access db and open it in SQL server express without having to mess around with the structure/format the of the db?

I assume SQL Serve express works with classic .asp websites (I don't do .net)

If I can, do I get a physical file like I do with access?

Finally, I have MySQL running on my PC currently, can I load SQL server express without it causing a conflict with MySQL?

Thanks.

Mat

Report · Apr 07, 2009

Mat,

Yes you can import Access into SQL Server Express. Got ahead and get 2008 Express, it is out now and should not interfer with MySql. I have both running on my development machine.

The Express comes with a tool called SQL Server Management Studio. You can use management studio to import the access file. First create a database then right click on the database name and select Task then import data. Then follow the pop up boxes. Most web site hosting companies provide MylittleAdmin to manage sql servers. MylittleAdmin is a lot like mysqladmin but more modern.

Yes the SQL server express works with classis ASP, and PHP.

David Pearson

http://www.saludalabs.com