Is there a way to import existing data into a new table, and have Toad be smart enough to map the columns with the same name or similar names. If there is anything Toad can not figure out, then the user will intervene.
Example:
Excel sheet with data has columns: c1, c2, c3
Table exists with columns: c1, c3_n, c4
Will Toad be able to map c1 with c1, c3_n with c3? The other columns will then be manually mapped by the user.
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center