GetSchema - need Columns in Ordinal Position

[Algonquin J. Calhoun]

Hello All,

I'm writing a small utility to assist my coding when using access tables. In this phase, I want to get the schema columns when creating a datatable
of columns and attributes using the statement:

dtc = cn.GetSchema("Columns", dtcRest)

I retrieve all the columns OK, but I want them to be in ORDINAL_POSITION (a column in the resulting table) sequence. I've tried everything I could
think of (ORDER BY), but just can't get it.

Now its time to try something that others have thought of.

Need some help.

Thanks,

Al

 

[Allen Browne]

For Access (JET) tables, many of the field properties can be read only
through DAO.

Here's an example of how to enumerate the fields of a table in order:
http://allenbrowne.com/func-06.html

If you need it, fields also have an OrdinalPosition property exposted via
DAO.