tags:

views:

80

answers:

2
Q: 

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?

+1  A: 

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

richardtallent  2009-07-16 14:21:20
A: 

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.

djangofan  2009-07-16 14:38:25

related questions

C++ SQLBindParameter
What Oracle driver should I install in my MS SQL server to be able to use DTS to copy data from the Oracle server to the MS SQL server?
Tool: ETL from an ODBC to SQL 05?
What is the simplest, most maintainable way to create a SQL Server ODBC Data Source?
How do I create a Jet ODBC link to a SQL Server view with periods in the field names?
Microsoft.ApplicationBlocks.Data.ODBCHelper ?
What are the access restrictions on accessing a DSN
.NET ODBC Connection Pooling
ODBC Connection Pool
what is the difference between OLE DB and ODBC data sources?
Reading a COBOL DAT file
Reverse Engineering for Database Diagramming in Visio with SQL Server 2008
How to programmatically configure an ODBC Datasource using C#
Best way to debug an ODBC driver on Windows
What is a Privileged instruction?
Control which columns become primary keys with Microsoft Access ODBC link to Oracle
How do you deal with NULL values in columns of type boolean in MS Access?
Using Rails 2.x with MS SQL Server 2005
C# ODBC Dialog
How do I get ms-access to connect to ms-sql as a different user?
How can I lock down my MS-SQL DB from my users and yet still access it through ODBC?
Using MySQL on Visual Studio 2008
Using MS Access & ODBC to connect to a remote PostgreSQL
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Connect PHP to an AS/400