getting at datatypes inside access

  • Thread starter Thread starter William Kossack
  • Start date Start date
W

William Kossack

Is it possible to get the data types for fields in ms access tables?

I'm trying to do this either with a query or through odbc
 
You can use

Currentdb.TableDefs("MyTable").Fields("MyField").Type

This will return one of DAO.DataTypeEnum values

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Data Mismatch in Excel 2010 4
giving a presentation on why accountants should learn someaccess...is what i say fairly accurate? 1
Pass Through Make Table 7
Too big for Access? 6
Add autonumber to a large table? 0
Number of query values and destination fields are not the same. 2
MS Oracle ODBC failure in Access 07 3
Pass-Through ODBC query *to* (not from) MS Access 4

Back
Top