Importing files into one excel file


  1. Posts : 255
    Windows 8 Pro
       #1

    Importing files into one excel file


    I have a script running that shows computer, name, mac address, serial #

    I have a folder of about 200 differnec CSV files that update when people log in.

    As it is now, I will create a single excel file and manually type in each computers info.


    Is there a way to grab all of the information from the existing CSV's and import them all into one CSV or excel file?
      My Computer


  2. Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64
       #2

    Hi,

    It might be easier to copy all CSV files into one CSV file, and then open that with excel, and save as an xls[x] file

    "copy /a *.csv newfile.txt"

    then rename the txt file as csv file. This is done because when you use the same extension as the file you are copying you will get an error saying the file cannot be copied on top of itself.

    The /a says they are ascii (text) files.

    Minus the quotes of course.

    Good luck
    Tanya
      My Computer


 

  Related Discussions
Our Sites
Site Links
About Us
Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd
All times are GMT -5. The time now is 12:14.
Find Us