Showing posts with label uploading. Show all posts
Showing posts with label uploading. Show all posts

Friday, March 23, 2012

Feedback on Merge Replication Error

dear all,
regarding the problem of not uploading the data from the
subscriber to the publisher though the merge agent is
successfult and the status is no data needed to be merged.
i checked the record in msmerge_contents , it doesn't
exist.
actually i checked with the table nick name and the
rowguid of the row i made modification in.
any help with that?
Thanks
Dalia,
does the trigger exist on the subscriber? If not then perhaps the exchange
type is incorrect.
Regards,
Paul Ibison

Wednesday, March 7, 2012

Fast Uploading Data from Client to SQL2000 Database

Does anyone know how to upload (bulk) data from a client (written in Excel VBA) to a remote SQL2000 database? Of coarse I tried "INSERT INTO" and rst.addnew but I noticed this is much, much slower as downloading from the same remote database.
Thanks.It tends to be faster if you can do this the other way round i.e. get SQL Server to load it from Excel rather than using Excel to load it into SQL Server.|||You can try to use BCP function or SQL DTS to import into the relevant table. This will automate your process and make it much faster. Sometimes, it depend on the indexing,size of a table or the design of the database for performance.|||BCP uses the filesystem which I cannot access from the client v.v.