Simple SQL Script will do it, or a DTS if you want overkill. ;-p
-----Original Message----- From: Ken Ferguson [mailto:[EMAIL PROTECTED] Sent: 21 November 2005 13:42 To: CF-Talk Subject: Re: Multiple Row Insert Into SQL from another database 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:224797 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=11502.10531.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
