How to "disassemble" a table???

JustAGuy
01-12-2004, 03:15 PM
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!

00100b
01-12-2004, 03:17 PM
Using the same method as what you have, there are the other properties of the Field object (like Type, DefinedSize, ActualSize, etc.).

JustAGuy
01-12-2004, 03:18 PM
Thank you so much!

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum