cancel
Showing results for 
Search instead for 
Did you mean: 

using dynamic input on excel files with different tab / worksheet names

SOLVED
Niladri
Meteoroid

Hi Joe,

 

My ask is to load 10 excel sheets ( 7 xlsx and 3 xls) into an Oracle table. In each of these excels, there are three worksheets - A , B and C. I need to load B from each of them. The structure of B is exactly same.

 

Your solution asks us to use Dynamic XLSX. When I put the sheet names that I do not want to use, ( A and C ) , it is giving me this error - The field ' Sheet names' is not contained in the record.

 

Please help.

 

Niladri

Maxholi
Atom

Hi Joe,

 

Is there a way to adjust this macro to be able to read in xls files as well?

 

The xls connection doesn't allow List of Sheet Names.

 

Thank you,

 

Max 

SkyW
Meteoroid

I am also having a problem with .xls files. I have a few workbooks that each contain a single sheet but the sheet name varies from month to month. Is there a way to bring in whatever sheet is available for this file type as well?

Highlighted
Abhi_C
Atom

Joe,

 

Your solution looks interesting. Would it be possible to provide a sample of your solution ?

 

Thanks !