You should build a DTS package that runs on a schedule every night. It will be easy to run those checks and make your inserts... with a DTS package.
--Ferg Michael Grove wrote: >I need to insert multiple rows into a SQL database from an Access Database. >Basically I have an ecommerce site with a bunch of products in it. We would >like to use these products in another application. I am going to run the >update nightly. After the first update the system will need to check and see >if the product id from ecommerce site exists in the products table of the >other system. If so it needs to skip it, if not it needs to add it. > >I seen somthing about a INSERT SELECT statment, but do not know if it is >possible to use this since I am in two different databases and two different >Data Sources. > >I think I can write a loop and if statment but thing that with the number of >products, we have it may bog the system down. Currently we only have about 800 >but this will triple in a few months. > >My other option is that I can and already am doing a CSV export, but how do I >import this and how do I prevent duplicates? > >any help would be much appreciated. > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:224791 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
