CODEWITHSUNDEEP
sql-server-2005odbc
JonasB
JonasB

Reputation: 270

Importing ODBC database to MS SQL 2005

How do I get a database from ODBC data source to SQL Server 2005? Can I use SQL Managment Studio Express for this?

Upvotes: 0

Views: 1093

Answers (2)

djangofan
djangofan

Reputation: 29669

It used to be called DTS, but every SQL Server 2005/2008 comes with something called SSIS that is used to import and export data. You can import data into a database from any source, including flat text file, or .xls spreadsheet.

Upvotes: 0

richardtallent
richardtallent

Reputation: 35363

Yes. Right-click on your database and go to Tasks: Import Data.

Upvotes: 1

Related Questions