Toad World® Forums

Inclusion of Excel to heterogeneous join - Header row as field names within build.


#1

I noticed that when pulling in Excel data sources to join in with either my Oracle or MySQL tables that the field headers are very generic F1, F2, F3, etc… Is there a way other than alias to get the field name to show up. This would be most helpful in the build function so that these are more user friendly to explain to users as to what I am joining together to get their data source together.


#2

When we connect to Excel we use the first row as column names. Can you post your Excel file so we can see?