CODEWITHSUNDEEP
asp.netsqlms-access
jjh
jjh

Reputation: 1

Import data to MS SQL Server for ASP.NET

I am running Visual Studio 2010. I do not have an SQL server license. All I have is what comes with VS2010. I have a large quantity of data in Access and Excel. Is there a way to convert these to an SQL format that is usable and save-able?

I have tried Access:

Upvotes: 0

Views: 255

Answers (3)

akiller
akiller

Reputation: 2472

As Chase Florell says you should be able to do it with the free express edition. If you need something more there's the developer edition which is the same as the enterprise edition feature wise yet costs ~$45. With SQL Server 2012 out next month you might want to hold back on buying that though.

Upvotes: 0

Jeremy
Jeremy

Reputation: 3951

If you are looking to upsize to SQL Server look into getting a SQL Server trial. You can get a 180 day trial here http://www.microsoft.com/sqlserver/en/us/get-sql-server/try-it.aspx.

Your company may be eligible for software programmes such as WebsiteSpark and Bizspark which include a full licence for SQL Server for free*.

*read the product description before signing up.

Upvotes: 0

Raymund
Raymund

Reputation: 7892

You can use SQL Server Express its free and using Management studio you can import your data from different data sources like Excel and Access

download it here http://www.microsoft.com/sqlserver/en/us/editions/express.aspx

Upvotes: 3

Related Questions