Hi Michael, I'd probably avoid using ColdFusion altogether to import the data. Instead, look into creating a DTS package through the MS SQL enterprise manager; DTS exists exactly for this type of situation.
-Joe On 11/18/05, Michael Grove <[EMAIL PROTECTED]> 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:224796 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
