Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Importing files into one excel file

02 Oct 2013   #1
mike6623

Windows 8 Pro
 
 
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 System SpecsSystem Spec
.
03 Oct 2013   #2
TanyaC

Linux Mint 17 Cinnamon | Win 7 Ult x64
 
 

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 System SpecsSystem Spec
Reply

 Importing files into one excel file




Thread Tools




Similar help and support threads
Thread Forum
Win 7 EFS. An encrypted file can not be opened after importing prv key
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...
System Security
I need help with a batch file that merges excel files into one
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...
Microsoft Office
Windows Mail importing eml files
Hi, I have just upgraded to Windows 7 and Windows Mail. My old drive was not in good shape and could not be left connected, so I had my Outlook Express email stored to a My Docs location, which is were they sit in an .eml file format. 1. I have tried to have Windows Mail import them - no luck...
Browsers & Mail
Importing a PST file to Outlook 2007 on Windows 7
I got a new computer at work and had backed up my old Outlook on a PST file. I have been trying to import that into the new computer and continue to get a message "The personal folder file (PST) is already in use in the current profile" Sorry for my lack of knowledge on this front but if...
Browsers & Mail
Problem importing .PFX file
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...
General Discussion
Can't open 2003 Excel Files in Excel 2007?
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...
Microsoft Office


Our Sites

Site Links

About Us

Find 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 16:04.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App