Batch Importing to Excel - Techist - Tech Forum

Go Back   Techist - Tech Forum > Computer Software > Programming
Click Here to Login
Closed Thread
 
Thread Tools Display Modes
 
Old 05-17-2012, 11:39 AM   #1 (permalink)
Newb Techie
 
Join Date: May 2012
Posts: 2
Default Batch Importing to Excel

Hopefully someone can help me.

I have around 300 files that i need to import the information contained in each into an excel file. I am currently just using

copy *.del test.csv

This is nearly perfect because it gets all the information from each file and pastes it into an excel document but the only problem is i need to get the file name included as well. Is this possible somehow?

Thanks in advance for any help
__________________

mlocy is offline  
Old 05-17-2012, 03:10 PM   #2 (permalink)
It's all just 1s and 0s
 
office politics's Avatar
 
Join Date: Jan 2004
Location: in the lab
Posts: 6,555
Send a message via MSN to office politics
Default Re: Batch Importing to Excel

use the same wildcard for the destination

copy *.del *.csv
__________________

office politics is offline  
Old 05-18-2012, 02:57 AM   #3 (permalink)
Newb Techie
 
Join Date: May 2012
Posts: 2
Default Re: Batch Importing to Excel

Hi,

Thanks for that solution i may have to use it that way. Unfortunately that way creates an excel file for each individual file so increase server space. I have found the 2 codes that i need i just dont know how to make them combine in the same batch code.
dir/b *.del > test.csv
copy *.del test.csv
mlocy is offline  
Closed Thread

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a password protected batch file with a batch file MattPwns Programming 2 07-03-2010 04:04 PM
Windows 7: Excel 2003 Slows Down After use and restart of Excel fixes it Boma Microsoft Windows and Software 1 12-21-2009 11:29 AM
How To Open Microsoft Excel Spreadsheets Without Excel Osiris Tips, Tricks & Tutorials 0 06-21-2009 11:52 AM
Batch scripting: Startup applications and close batch file LincolnX Microsoft Windows and Software 7 01-17-2008 07:50 PM
importing flash into ms excel BlkShdw88 Microsoft Windows and Software 3 04-04-2006 10:53 AM



Copyright 2002- Social Knowledge, LLC All Rights Reserved.

All times are GMT -5. The time now is 02:00 PM.


Powered by vBulletin® Version 3.8.8 Beta 1
Copyright ©2000 - 2017, vBulletin Solutions, Inc.