DWUTKA at marlow.com
DWUTKA at marlow.com
Fri Feb 13 12:09:12 CST 2004
I just sent you my 'Drive Mapper' utility (mind you, I wrote it a while back....), which 'records' the files and folders in a drive, into a normalized structure. drew -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of O'Connor, Patricia Sent: Friday, February 13, 2004 11:55 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] OT - file search results save Thanks Jim I would greatly appreciate it. Whenever you get to it. Thanks > -----Original Message----- > From: Jim DeMarco [mailto:Jdemarco at hudsonhealthplan.org] > Sent: Friday, February 13, 2004 12:49 PM > To: Access Developers discussion and problem solving > Subject: RE: [AccessD] OT - file search results save > > > Patricia, > > I don't have it handy but I put together an utility app that > loops through our network and adds this information to an > Access table (A97). Put simply use the Dir command in VBA > and then use ADO or DAO to save any found item to the table. > If you like I can look for it but it's been quite a while > since we've run it and may take some time to find. > > Jim DeMarco > Director Product Development > Hudson Health Plan > > > -----Original Message----- > From: O'Connor, Patricia [mailto:Patricia.O'Connor at DFA.STATE.NY.US] > Sent: Friday, February 13, 2004 12:33 PM > To: 'Access Developers discussion and problem solving' > Subject: [AccessD] OT - file search results save > > > I did a search of one of our server drives for all *.MDB > using the Windows > 2000 search. Give name of file, directory, size, modify > date. Great just > what I want, except I can not figure out how to get the > results into a file > - word, text, excel > > If I do save results, it puts it into a file but all that > seems to do is > save the search string. > > > Does anyone know how I can save the listing or have a utility > that will > allow me to save this in a file. It is probably something > simple but I am > just getting no where. > > Thanks > Patti > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > > > > > _______________________________________________ > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com > _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com