RE: CFQuery to mdb

2011-01-06 Thread Rick Eidson
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. I asked the same question... It's political and we's IT people don't not know what were talkin bout... One of the

RE: CFQuery to mdb

2011-01-06 Thread Rick Eidson
Thanks! Looks like I am kind of on the right track... I will read up on this link... Rick -Original Message- From: Mark A. Kruger [mailto:mkru...@cfwebtools.com] Sent: Wednesday, January 05, 2011 9:23 PM To: cf-talk Subject: RE: CFQuery to mdb You can seed a database with the schema

RE: CFQuery to mdb

2011-01-06 Thread Leigh
Rick Eidson wrote: It's political and we's IT people don't not know what were talkin bout... Oh. One of those deals. (How familiar ;-) Well it looks like Mark has you on the right path. Mark wrote: While I agree with you about a CSV file in many cases, Leigh, sometimes this is useful

CFQuery to mdb

2011-01-05 Thread Rick Eidson
I want to output the results to a MSAccess database file. I can output the results to a xls file pretty easily but I need to create a database and save the results to a table. I thought about creating a temp blank database and then creating the table, writing the data to it then copy the

Re: CFQuery to mdb

2011-01-05 Thread Leigh
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

RE: CFQuery to mdb

2011-01-05 Thread Mark A. Kruger
- 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