Batch Importing to Excel

[mlocy]

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

 

[office politics]

use the same wildcard for the destination

copy *.del *.csv

 

[mlocy]

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