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 |
|
Ms.Feroghi
Starting Member
1 Post |
 Posted - 2009-04-22 : 01:52:35
|
| Hi everyone!I have to import 481 records from excel sheet into a sqlserver 2005 table which already has 664 records and I am using import wizard for that..Now the problem is that I dont understand "where not exists" but I have used the simple insert statement ..OK I going to give the table name and the feilds' name! somebody please edite it for me..INSERT INTO ASICActivity(ID,Code,Name,,SectorID,TypeID,SubNDPCode)VALUES (ID,Code,Name,,SectorID,TypeID,SubNDPCode)I’ve got problem for your solution…Feroghi |
|
|
aprichard
Yak Posting Veteran
62 Posts |
Posted - 2009-04-22 : 03:05:33
|
| You try to use "OpenRowset" instead of import wizard for importing Data |
 |
|
|
bklr
Master Smack Fu Yak Hacker
1693 Posts |
|
|
|
|
|
Importing Data