IMPORT DBF File into SQL 2000

Member 4650287

Dear all, I have 3 Dbf files that have to be imported to Sql Server 2000.Master table & dbf files are same fields n data type.Can anyone help me ?

i i i

you want to merge them or want to overwrite ?

Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...

Member 4650287

thanks for reply. I just want to merge with old datas.

i i i

You can use Import Data Option exists in Sql Server but it will not let you insert data if their are any constrains made on the column of the tables means if their are constrains like no duplicate etc... then it will not let you otherwise it will work here are some softwares for merging data also http://wareseeker.com/free-sql-merge-tables/[^] i made one utility which exports data into an xml file then can import that data into sql server if you can make a utility then it will be another option

Best Of Regards, SOFTDEV Sad like books with torn pages, sad like unfinished stories ...