Thread: Import on SQL2005

Hi All,

On SQL2000 I usually find my table, right click, choose new task, and Import to import data from excel into my table.

I don't see this option in SQL2005, how do I do this in 2005?

Thanks!

Originally Posted by Wolffy

Right Click on the Database->Tasks->Import Data...

Ok, just found it...w00t. Thanks w0lffy.

Another question....which are you suppose to pick ODBC SQL Server or SQL Native Client for the destination?

its defaulting to SQL Native Client but that doesn't seem right to me.