sql - Get column names -


I need to get all column names in the table using VBA or Access SQL and repeat them for verification Does anyone have the solution to this, I have not taken any advantage to Google.

this will work

  set db = CurrentDb () set rs1 = DB.OpenRecordset ("Table1") Set DAF field as DAO field for DMA. Next set in Rs1.Fields MsgBox (fld.Name) fld = None  

Comments

Popular posts from this blog

c# - sqlDecimal to decimal clr stored procedure Unable to cast object of type 'System.Data.SqlTypes.SqlDecimal' to type 'System.IConvertible' -

Calling GetGUIThreadInfo from Outlook VBA -

Obfuscating Python code? -