You can also loop through ADOX.Columns collection to retrieve all columns info.
However in all cases you'll need to convert ADO data types to FoxPro types. IMO it may be better to get columns info using ODBC and SPT SQLCOLUMNS() function with FOXPRO option.

>I have a side question on this one. In my app, I need to read the table structure from a MSSQL2K database and then do my "Create Table" structure. Do you know how I might easily do that with ADO (using the Connection object reference to my MSSQL2K box)?