Total Field Count
 

I have connected an excel workbook to an access database. Is there a
function in VBA that will return the total field count of an access table?

Total Field Count
 

Assume you use data=Get External Data (or Import External Data)

Assume table is returned starting in cell A1 of Sheet3 and there is no other
data on the worksheet

=CountA(Sheet3!1:1) will give the number of fields (columns)

--
Regards,
Tom Ogilvy

"Markantesp" wrote in message
...
I have connected an excel workbook to an access database. Is there a
function in VBA that will return the total field count of an access table?