>>But now the folks in Marketing want to export the data and then import it back into the database.
That sounds dangerous. ;) I had a (somewhat) similar request a while back. Where a company wanted to generate sales reports from the DB. So instead of giving them data dumps, I used Access as a front end to the (Mysql) DB using MyODBC. So they could run reports all day long on the live data and not bother me. It was read only btw. You might export it to a holding table while they edit the data and then rename the tables when they are done. I know that you can use access as a front end for MSSQL as well. Just a suggestion. G On Wed, Apr 23, 2008 at 4:08 PM, <[EMAIL PROTECTED]> wrote: > Hi All, > > I've built a store location and an admin tool to maintain the store data. > But now the > folks in Marketing want to export the data and then import it back into > the database. > > I planned on just exporting the data to a xls file and then import the > same xls after it's been > updated at a csv. I just get nervous when there's too much exporting and > importing. > > Does anyone have any other ideas that they themselves have successfully > implemented? > > Thanks > > D > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;192386516;25150098;k Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:304106 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
