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