 |  |  |  |  |  |  |  |
How can I import data from search to Excel
 |
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.
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.
•
•
Join Date: Mar 2005
Posts: 1,213
Reputation: 
Solved Threads: 36
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.
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.
|
Similar Threads
- Reading excel data using vb 6.0 (Visual Basic 4 / 5 / 6)
- how to import excel data into mySql (PHP)
- error C2664 (C++)
- Internet Explorer & Windows Explorer (desktop shortcuts) Won't Load! (Viruses, Spyware and other Nasties)
- really need help, please! (Viruses, Spyware and other Nasties)
- Eliminate Adware Attack (Viruses, Spyware and other Nasties)
- How to export excel data to a search engine? (MS Access and FileMaker Pro)
Other Threads in the Windows NT / 2000 / XP Forum
- Previous Thread: Is it possible to format a partially formatted HDD?
- Next Thread: Anyone wake there pc with the AMD magic packet?
| Thread Tools | Search this Thread |
Latest Windows NT / 2000 / XP Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Windows NT / 2000 / XP
.net 3.5 3daccelertion 2007 2010 activedirectory alaris android application audio auto automatically black blue book bulletin canonical cellphones chinese chkdsk collaboration computer crash deployments desktop domain dotnetnuke drive dual error errors explorer features folder fonts format hardware internet interoperability killprocess laptop laptops lcd linux load mac memory microsoft mobile monitor motionle1600 netbooks novell open operatingsystems oracle osinstallationproblem partition product proxy raid rds remotedesktopconnection repair retail retrieve rootkit screen security server. slowperformance sp1 sp3 spyware studios technology ubuntu uninstall update upgrade usb verizon videogames virtual virus vista visual volume wab webos weecam win win32/heur windows windows7 windowsxp windowsxpnotstartingup. worm xp xpde
