>Ok, I give up! Well, I haven't spent too much time on it because I know some of you know the answer. I have tried creating a view against certain tables in SQL Server 7 and VFP chokes with an error message sayign too many columns. I also tried using Sqlcolumns() and got the same thing. Is there a way to iterate through the column names in VFP?

You could use SPT and use the SP_COLUMNS system stored procedure for this. You could iterate through the resulting cursor.

Ex.
=sqlexec(lnconn,[exec sp_columns 'mytable'],'c_columns')

HTH.