How to "disassemble" a table???

Hi!

I was looking around and know that I can get the name of the columns of a table just using the small routine bellow.


Dim f As Field
For Each f In rs.Fields 'rs is your RecordSet
ListBox1.AddItem f.Name
Next


Well, I would like to know if there is a way to get the type of each of these columns as well its length...

Thanks!

Using the same method as what you have, there are the other properties of the Field object (like Type, DefinedSize, ActualSize, etc.).

Thank you so much!