Skip to main content
matthew stuart
Inspiring
April 7, 2009
Question

Access to SQL Server 2005 Express

  • April 7, 2009
  • 1 reply
  • 545 views

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

This topic is closed to new replies. Start a new post to keep the conversation going.

1 reply

DEPearson
Inspiring
April 7, 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

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices