Hi,
How can I update data in MSDE 2000 when I have new data in Access every
month?

Thank you.
Shailesh

hi Shailesh,
[quoted text, click to view]

you can design and distribute a DTS, or create a home made data pump to
transfer, say via ADO, ADO.Net, data from Access to MSDE database, or BCP
new data in, from an Access Text export, or (manually) generate INSERT INTO
scripts from the Access database, or create a linked server pointing to the
Access db and perform INSERT SELECT operations...
--
Andrea Montanari (Microsoft MVP - SQL Server)
http://www.asql.biz/DbaMgr.shtm http://italy.mvps.org
DbaMgr2k ver 0.9.1 - DbaMgr ver 0.55.1
(my vb6+sql-dmo little try to provide MS MSDE 1.0 and MSDE 2000 a visual
interface)
--------- remove DMO to reply