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

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

Thanks,
I'll run several tests on the first few lines.
If they are all numeric, I'll stick with that, otherwise it will be
text.

Thanks for your help.

KR
Peter