Tom, As Isaac mentioned his DataFaucet project and my DataMgr project will both create tables and columns from XML. DataMgr will also allow you to define the data (not sure about DataFaucet):
http://www.bryantwebconsulting.com/docs/datamgr/synchronize-database-structure-activeschema.cfm http://www.bryantwebconsulting.com/docs/datamgr/seed-data.cfm Thanks, Steve > Hello, > I was wondering if there were any libraries or functions which can be > used to create database tables on the fly based on XML data and then > insert the data. So all I had to worry about was formatting the xml > data. > > Thanks, > tom ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329003 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4