Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AndyC
Yak Posting Veteran
53 Posts |
 Posted - 2006-04-07 : 15:15:53
|
| using sql 2005 express for first time using management studio express to import some tablestriedIn SQL Server Management Studio, connect to the Database Engine server type, expand Databases, right-click a database, point to Tasks, and then click Import Data or Export data.does not appear to be avail in express versionAm I missing something here?Andrew Clarkwww.majorleaguecharts.com |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-04-08 : 08:19:07
|
| Unfortunately, SQL Server Express edition does not have import/export wizard. You will need to have at least workgroup edition (or developer edition) if you would like to use that wizard.You can create a linked server in the express pointing to your SQL2K database and then using select * into <new_table> from linkedserver.databasename.owner.tablename you can import it into SQL Express |
 |
|
|
AndyC
Yak Posting Veteran
53 Posts |
|
|
|
|
|
import possible