using a worksheet to collect data for access import
 

hi i want to use an excel worksheet to collect data that I will then import
into access. How do I enforce the datatype of data entered into a column of
say dates?
thanks

using a worksheet to collect data for access import
 

RHC,



For data entered into a sheet, use the Validate feature. If this is too
limited, you can use forms and include much more extensive validation; but
you will have to write a lot of code.



A third trick is to use UDF to capture input, validate (or fix) and write
back to the sheet. Of course the UDF must be in a cell other than the input
cell and you may have to play games with the VOLATILE command to avoid a
never ending circle. This trick is useful when you want to validate a lot
of cells at once on a manual or programmed compute.



Allan P. London, CPA

"The Future and Reality - Close the Gap"







"RHC" wrote in message
...
hi i want to use an excel worksheet to collect data that I will then
import
into access. How do I enforce the datatype of data entered into a column
of
say dates?
thanks