Getting file name in the table imported

Hi Padma, I have a script that does that: http://ideascripting.com/ideascript/add-filename

Is this what you are looking for or are you looking for something else.

Brian

Hi Brian,
This is good but it works when the database is open in IDEA. So when i have many files, i need to do it one by one.
I have to consolidate 50 excel files with 7 sheets in each file. So i would like to have file name in each of the sheets imported. Some of the files would have blank data also. Can you help me with a script to handle mutiple files and sheets.
I am enclosing a sample for your reference. 

Hi Padma,

Can you confirm my understanding.  You would like a script that does the following:

• Imports multiple excel sheets along with all their work sheets.  So in your example of 50 excel files and 7 sheet per file there would be 350 IDEA files
• For each IDEA file a column would be added called Filename that adds on the filename of that file.

Is that right?  Thanks for the example files.

Brian

Yes Brian. Your undestsanding is right.