Drawbridge.Jack at ic.gc.ca
Drawbridge.Jack at ic.gc.ca
Wed Jan 26 15:19:47 CST 2005
I'm sure someone has a solution to this.
I have A2K and am using ADOX to retrieve the structures of existing tables.
When I use this type of approach
Dim cat As New ADOX.Catalog
Dim tbl As ADOX.Table
Dim col As ADOX.Column
cat.ActiveConnection = CurrentProject.Connection
for each tbl in cat.Tables
If tbl.name = "Table I'm Looking For" then
for each col in tbl.Columns
debug.print col.name
next col
endif
next tbl
I get the column names, but in ascending name order. How do I get the
Column Names in the physical order in the table??? Does someone have
sample code?
TIA
jack