import data from xls to SQL

[Kilpone]

A problem with my replication system as occured.

I have a working SQL server that can do replication trough internet, everyting works

The problem is when I try to import large amount of data (10000 rows) to my database on the SQL server

the subscriber on my client don't get the new inserted rows. That will say imported data is not being replicated.

only rows that i have manually inserted will be replicated.

I used the import wizard that came with SQL server.

Is there a solution to this problem?

[rmiao]

What kind of replication do you use? How do you import data? If you import data with bcp and use transactional replication, then imported data will not be replicated since bcp is not logged process.

[Kilpone]

I'am using merge replication, import is done by "Microsoft SQL server Management Studio -> Tasks -> import Data Wizard"

I import data directly to SQL Server database (one table)

what is "bcp"?

[Kilpone]

Hi

I found a solution to this problem!

sp_addtabletocontents did the job for me.