I have worked with ODBC data connections for a while. Usually, I've setup a connection to some type of database (IBM ISeries, SQL Server, Progress, etc.) depending on the project and then I use MS Access to inspect or export the data using linked tables.
I have a database that has numerous tables and columns. In fact, I believe there are some 16k data columns in the entire database. Furthermore, I have an excel file that gives me a list of all of these tables and a brief description of each column
but it does not have useful data types in the description. What I would like to do is query the ODBC source and extract each table, it's columns and it's column data types.
My end goal is to take the data from the spread sheet (column names and description) and insert that data into a database that also contains the correct, SQL data type in an additional field. Is there a way to query an ODBC data source to acquire all
of this information?
View Complete Post