What is the name of the function that returns the number of colum.

[Eliud Ramos]

Hi:
I need help!
I know there is a function you can use from Visual Basic that returns the
number of columns of a datasheet that need to be imported.
You help is appreciatte.

 

[John Nurick]

I don't know what you mean by "a datasheet that need to be imported",
but assuming it's an external table of some kind what I'd do is

1) write a SELECT * query
2) open a recordset on the query
3) examine recordset.Fields.Count

On Thu, 21 Apr 2005 14:59:04 -0700, "Eliud Ramos" <Eliud