Hi
I'm using a Pass-through query in Access 97 (i know, old version!!) to get data out of an ODBC database.
The problem is, the database has over 250 fields so I cannot get all the data using a standard link-table in access, & as a result, I don't know the ODBC field headers for the data i need (they are past the 250 limit).
Is there anyway of getting a list of all the field headers of an ODBC database?
Hope this makes sense!!!!
Thanks
I'm using a Pass-through query in Access 97 (i know, old version!!) to get data out of an ODBC database.
The problem is, the database has over 250 fields so I cannot get all the data using a standard link-table in access, & as a result, I don't know the ODBC field headers for the data i need (they are past the 250 limit).
Is there anyway of getting a list of all the field headers of an ODBC database?
Hope this makes sense!!!!
Thanks