PDA

View Full Version : Sql Server 2k Qns



thebmwz4
Jan 10th, 2006, 03:11 PM
hI ALL, wanna ask a qns on import function in sql 2k database. i wanted to "import" in a database table details and overwrite into the relevant databse. however, when i used the import function, the details are added into the prevailing data in the table instead of overwriting the entire table. thus there are repeated data enrties and the table is wrong.

Wanna askif there is a way to overwrite the entire database table from an excel sheet where the data is alreay written into the excel sheet?

thanks!!

ronaldb66
Jan 10th, 2006, 03:32 PM
This question seems more in place in one of the server side forums.

Please do not cross-post as per the forum Rules (http://www.codingforums.com/rules.htm); I'll ask a moderator to move it.

By the way: which DBMS are you using?


May I suggest as well that you get a better keyboard? Your posts are rather hard to read with all the missing characters... :rolleyes:

thebmwz4
Jan 10th, 2006, 04:10 PM
hi, wat ya mean by DBMS?
i am using MS SQL SERVER 2K version 8.00.194

thanks!

Roelf
Jan 11th, 2006, 01:45 PM
cant you just delete the existing records before importing the data???