Importing data | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Importing data

SQL 2000 had a import/export wizard. What doe SQL 2005 have to do this work? I simply want to be able to import data from an excel spreadsheet, and be able to select which columns I wish to import. The How-To I found referenced using a SQL ServerBusiness Development Studio project for importing, but I could not find the reference. I don’t have the exact name of the project mentioned, but it was not available in my list of projects. Can someone shed any light on how to do this? Thanks. Marshall
You can still import/export data in SQL Server 2005. Right-click on a database in the SQL Server Management Studio and choose import. You can then choose Excel, OLE source, etc. You can also save the import as an SSIS package, just like you could save a DTS package. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
Commandline: dtswizard
See if you are able to do the same in SQL Server 2005 also Madhivanan Failing to plan is Planning to fail
Thanks, D. I found the import feature. I was right-clicking on the database itself, instead of the database group. It was found there. Marshall C Youngblood
Another question on this topic. I want to create a unique identifier for each record I import, but that field does not exist in the spreadsheet. How can I force the import wiz to create and populate that field, and then to populate during subsequent imports? I tried modifying the SQL statement that creats the table by adding the line [ItemID] uniqueidenifier, but the import failed. Thanks. Marshall
Do the import first, then add the uniqueIDs. for further reference. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.