How to add file name to its columns for many files

[EXCELTROUBLE123]

Hellow Guys,

I am trying to solve a problem.


Exchange is generating one data file per day, and file name contain its date like EQ01012016.xls, EQ10082017.xls and so on. this date is missing inside the file.

I want to add date from file name to one of the column of the file. this need to be done to all the files.

is there and smarter way then copy paste.

I have 220 data file from stock exchange with 3000+ records each without date.


thanks

[CK76]

How are you using that CSV file?

Are you importing the data to your reporting workbook?

It's not very efficient to update each file. I'd recommend adding column at import stage.

Exact method will depend on how you are importing the data.

[EXCELTROUBLE123]

yes finally all the files need to be uploaded into a database, but as the date is missing wanted to add it first.
pls suggest the best want.

thanks a mil

[CK76]

It would help if you specify what database (SQL Server, MySQL, Postgre etc) and version.

Best approach will depend on it.

If SQL, I'd imagine that you can query folder first, and create temp table to store file name, then loop.

See link on how to add column with filename using Bulk Insert.
https://stackoverflow.com/questions/...owing-filename