You can use the vartype function or the typename function.

However, Excel isn't a database, so each cell in a column can be different.

--
Regards,
Tom Ogilvy


"XPete" wrote in message
oups.com...
Hi all,
I am trying to write some code to put an excel dataset into a new
access table.
For this I need to set the field properties in Access. That is not the
issue, but I need to know to what parameter to set it to.
Does anyone know how to retrieve this from excel (eg. number, text,
date etc.)

Thanks in advance
Peter