My suggestion would be to go to http://www.cfcomet.com/cfcomet/sql_server/ - the first article is about exactly what you're trying to do.
Mark -----Original Message----- From: Declan Maher [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 6:08 AM To: CF-Talk Subject: RE: Using a DTS package Can anybody advise me what is the best/simplest way of converting a SQL Server database to Access in the following instance. My user needs to be able to just go to the website click on a button and the database needs to be converted. Then the user can just download the Access db and analyse it with certain software they have. Somebody has suggested using a DTS package before but I'm still not sure how this is executed from Coldfusion. If anybody has an code or tips they would be greatly appreciated. Thanks, Declan ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
