searching

[Guest]

I am trying to search for all the .mde and .mdb databases on my servers using the inbuilt search option in windows

Once I have found these files I then want to export the search results as a csv files or some other format that can be opened either in excel or in access

Can somebody let me know if this is possible or if not is there any package out there that can do this

Thanks

 

[Will Denny]

Hi

Try this:

From a command prompt - root folder - type the following:

dir *.mdb /a/s > search.xls

You can then open that file in Excel - the .xls file can be called whatever. The same applies to .mde files to view them in Excel.

The output to an .csv file doesn't seem to show up properly in Excel.

 

[Torgeir Bakken (MVP)]

I am trying to search for all the .mde and .mdb databases on my servers using the inbuilt search option in windows.

Once I have found these files I then want to export the search results as a csv files or some other format that can be opened either in excel or in access.

Can somebody let me know if this is possible or if not is there any package out there that can do this.

Hi

Use the free Agent Ransack instead to search for files...

http://www.agentransack.com/default.aspx

Agent Ransack can save the search result to a file (or clipboard), as text,
comma separated text or tab separated text. E.g. Excel reads comma separated
text (csv) very well.