Importing files into one excel file


  1. mike6623
    Posts : 255
    Windows 8 Pro
       New #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
    Quote Quote

  3. TanyaC
    Posts : 784
    Linux Mint 17 Cinnamon | Win 7 Ult x64
       New #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
    Quote Quote

 

  Related Discussions
Importing PST file
in Microsoft Office

I'm wanting to import a PST file into my Outlook 2013 and the process looks rather straightforward except confused on which to select below. Should it be Option (1) or (3)? I had to do an image restore and in the process lost some emails but Carbonite was there as a safety net with some PST...
My first post in SevenForums. Any guidance on where to post things, etc. appreciated! I did look for a forum on file system issues, then looked over all forums, then decided to post here. I have a file containing sensitive info that I use daily. It's encrypted with Windows EFS, showing as green...
This is what I want to achieve: I want to merge all excel files in a directory into one .csv file. The files in the directory are only *.xls, *.xlsx, and *.csv . I use a simple batch file that I put in the directory which has the following script: echo off copy /a *.* merged.csv pause And...
Problem importing .PFX file
in General Discussion

Hello guys, I am in a trouble, hoping for some help. I had encrypted my important folder on Windows 7 and the type of file that was exported was .PFX Then after due to a reason (it's a long story), I reinstalled windows 7 on partition containing old windows 7. Now, I can't access my...
I'm not sure if it because the files are 2003 or not? When I try to open them an error message appears stating, "...the file you are trying to open is in a different format than specified by the file extension. Verify file is not corrupted and is from a trusted source..." These are my files. The...
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 13:00.
Find Us