How to count columns of the MS Access database using Visual Basic programming?
Can anyone please tell me how to count the horizontal COLUMNS in Microsoft Access database using Visual Basic programming? Thank you.
Re: How to count columns of the MS Access database using Visual Basic programming?
your question is confusing. columns are never horizontal, they r vertical...considering u want to count the number of fields, i.e columns, open up a recordset and use the 'fields' property.
iFldCount = rs.fields.count