Friday, March 9, 2012

Importing data into SQL

With SQL 2000 there was an Import/Export facility for importing data into a Sql database. Could somebody tell me how to import an old database which could be in Csv text or Paradox into my new SQL 2005 tables. Thanks

In Management Studio, connect to any sql server instance, right-click on a database > tasks > import data

This will take you do the import/export wizard

|||

Start -> Run -> dtswizard.exe will also bring up the Import Export Wizard for you.

No comments:

Post a Comment