You can seed a database with the schema then access it through passthrough file syntax... .a single "prepared" temp DB could do the trick.
Basically you have a dummy access DSN setup, then you copy your prepped access file to a temp location, load it with data using the passthrough method, and then allow the user to download it (I usually zip it first). Here's a link to a post on the passthrough method. http://www.coldfusionmuse.com/index.cfm/2005/6/3/dsn_cfmx While I agree with you about a CSV file in many cases, Leigh, sometimes this is useful for exactly the reasons you are suggesting - that extra "access" stuff allows you to create form interfaces, premade queries etc - enhancing off line data mining for the user. -mark Mark A. Kruger, MCSE, CFG (402) 408-3733 ext 105 Skype: markakruger www.cfwebtools.com www.coldfusionmuse.com www.necfug.com -----Original Message----- From: Leigh [mailto:cfsearch...@yahoo.com] Sent: Wednesday, January 05, 2011 7:17 PM To: cf-talk Subject: Re: CFQuery to mdb > just seems like more than I need to do. I do not think so. It is not like exporting html/excel. An Access database consists of more than just the data itself (system tables, etcetera). So I am not sure there is a simpler way. Maybe using ms sql's export tools .. But why does it need to be a full Access database? Providing a delimited file users could import is simpler and more flexible. As it could be imported into both Excel and Access. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:340494 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
