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:224710 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
