How can I import data from search to Excel

Reply

Join Date: Oct 2008
Posts: 2
Reputation: Susan Roden is an unknown quantity at this point 
Solved Threads: 0
Susan Roden Susan Roden is offline Offline
Newbie Poster

How can I import data from search to Excel

 
0
  #1
Oct 24th, 2008
I work in the IT department. I have been given the task of compiling a list of all the Access databases we have on our server and creating an Excel spreadsheet (using MS office 2007) with certain data such as name of database, access date, owner etc.

My problem is if I do a search using My Computer the list I'm given is perfect except I cannot get that data from that screen into Excel. Using Command prompt is very cumbersome and I can't seem to get a good format to save the data and it be useable.
Reply With Quote Quick reply to this message  
Join Date: Mar 2005
Posts: 1,213
Reputation: zeroth is a jewel in the rough zeroth is a jewel in the rough zeroth is a jewel in the rough zeroth is a jewel in the rough 
Solved Threads: 36
zeroth's Avatar
zeroth zeroth is offline Offline
Nearly a Posting Virtuoso

Re: How can I import data from search to Excel

 
0
  #2
Oct 24th, 2008
have you tried the Data tab / Text to Columns command in Excel to delimit the data from the redirected text file?


"No one remembers who climbed Mount Everest the second time." — Na Nook.
Reply With Quote Quick reply to this message  
Join Date: Oct 2008
Posts: 2
Reputation: Susan Roden is an unknown quantity at this point 
Solved Threads: 0
Susan Roden Susan Roden is offline Offline
Newbie Poster

Re: How can I import data from search to Excel

 
0
  #3
Oct 27th, 2008
Yes I have tried that but when I get a list using Command prompt it has so much information in it that when the cells are split in Excel using the Data / Text to Columns the data is not put into useable columns. I'm also new to using MS Office 2007.
Reply With Quote Quick reply to this message  
Join Date: Nov 2008
Posts: 17
Reputation: gordon451 is an unknown quantity at this point 
Solved Threads: 0
gordon451's Avatar
gordon451 gordon451 is offline Offline
Newbie Poster

Re: How can I import data from search to Excel

 
0
  #4
Nov 15th, 2008
Dumb question time. Have you tried the Indexing Service?
____________________
Sugar, greasy foods and Microsoft are dangerous to your health -- eat, drink and be merry!
Early to bed and early to rise makes a bloke crook, broke and stupid.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Windows NT / 2000 / XP Forum
Thread Tools Search this Thread



Tag cloud for Windows NT / 2000 / XP
About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC