rogue
rogue

Reputation:

How to import excel files into SqlDatabase .mdf file

I have one long excel sheet with books details of a library..can i import this data into a .mdf file.

Upvotes: 0

Views: 9349

Answers (3)

Geoffrey
Geoffrey

Reputation: 5432

Here is a step-by-step guide from the horse's mouth: http://support.microsoft.com/kb/321686

Upvotes: 0

Vnuk
Vnuk

Reputation: 2703

Yes. Depends on SQL Server version you have installed (for exact instructions) but you use DTS (Data Transformation Services).

Right click on your database and you should see Import data. Wizard will do most of the work, basically it's a next next next operation.

Upvotes: 1

m1k4
m1k4

Reputation: 829

You will need SQL Server Management Studio, and use its Import feature

http://msdn.microsoft.com/en-us/library/ms141209.aspx

Upvotes: 0

Related Questions