I am creating access tables dynamically from a recordset that is opened using an oracle query. So if the user query returns 3 fields, I create an access table with 3 columns using names from the field collection of the recordset. The problem I have is I cant see to find where the number of decimals is stored in the fields collection that is returned in the recordset. I have looked through all the properties returned for each field and dont see one. It returns a dbdecimal type, but I convert that to dbdouble and it defaults the decimal places to AUTO. I need to know the number of decimals because ultimately, this will be formatted into an excel xls (via vba) file based on the table properties. If I use AUTO for the number of decimals, when I format the vba code, I won't know how to format the cells properly. Trying to automate as much of this process as possible to eliminate user manual effort. I used access's transferspreadsheet to create the xls, but it doesn't do any cell formatting for various types. I can set the number type with number of decimals if I can determine how many decimals the field should be.FYI, I'm using the oracle odbc driver for the oracle connection.
hope that makes sense.