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

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

Linux Mint 16 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 for2: Importing files into one excel file
Thread Forum
Windows Mail importing eml files Browsers & Mail
Importing a PST file to Outlook 2007 on Windows 7 Browsers & Mail
iTunes Importing Video Files Music, Pictures & Video
Problem importing .PFX file General Discussion
Importing eml files into Outlook 2010 Software
importing image files Network & Sharing
Can't open 2003 Excel Files in Excel 2007? 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 01:45 AM.
Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App
  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33