Creating an Excel column

[AgentM]

Hi,

I am trying to import data from an Excel spreadsheet to an Access database. But my final table should have columns with datatype date and boolean.
Q1. Can I have some kind of data evaluation for an excel column. So that if there is a column called 'TDate'
I would want all the rows in that column to contain data in a date format, If it is not in the data format it will replace it with a default value.

Q2. Are there any intelligent tools in the market that I can use for this migration.

Thank you

 

[ETID]

The following formula in cloumn A of sheet2 assumes dates are in column A on sheet1 and sheet2 column A is formated as (mm/dd/yy) date.

=IF(ISERROR(DAY(TEXT(Sheet1!A10,"MM/DD/YY&quot)),"",Sheet1!A10)

fill down and import sheet2 to access.

 

[ETID]

Ooooops A10 should be A1 ... sorry