How to Use the SQL Server Import and Export Wizard


show more Using the SQL Server Import and Export Wizard provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training show less
please wait ...

Using the SQL Server Import and Export Wizard

It's a very common need that when creating a database we need to import some data that exists somewhere else. That could be in an Excel file, a CSV file, an Access database, even another instance of SQL Server or a previous version of it, or we can do all of these things using the SQL Server Import/Export Wizard. Under my installed programs for SQL Server 2008 R2, I actually have this link, Import and Export Data 32-bit and 64-bit, I have two versions. Now the reason for that is that while my SQL Server instance is installed as 64-bit, some of the data sources that I might want to import from or export to aren't 64-bit so I need to talk to them using the 32-bit version, and basically if one of them doesn't work try the other.

So I've opened the wizard here. It just gives me a greeting message that it will copy between databases, spreadsheets, text files, and so on. I'm going to click Next because I need to give it two pieces of information: where am I copying from and ...

Using the SQL Server Import and Export Wizard
Video duration: 3m 58s 6h 54m Beginner

Viewers:

Using the SQL Server Import and Export Wizard provides you with in-depth training on Business. Taught by Simon Allardice as part of the SQL Server 2008 Essential Training

Subjects:
Business Developer IT
Software:
SQL Server
Author:
please wait ...