CODEWITHSUNDEEP
sqlt-sqlimportsql-server-2008-r2
Jon
Jon

Reputation: 239

Create a local DB and import csv or excel file

Due to circumstances beyond my control, I'm currently not able to create a table on one of my company's databases, and I got a project where I need to break down and get stats from a large data file. I can open it in Excel, but its not very happy about it. What I'd like to be able to do is create a local database where I could use the import wizard to import an excel file to a new table. Is this possible? If so, how would I do it?

Upvotes: 0

Views: 2604

Answers (1)

Brian DeMilia
Brian DeMilia

Reputation: 13248

SQL server has a free express edition of their database http://www.microsoft.com/en-us/server-cloud/products/sql-server-editions/sql-server-express.aspx. It probably has a cumulative data limit though (Oracle express does, I don't know much about sql server express).

Upvotes: 1

Related Questions