Import HTML table date field

J

JohnGAtMayo

How to import date field from an HTML table in this format: 12/18/2003
9:43:11 AM
I have used the Import Table wizard. It imports the other field, but gives
me "Type Conversion Failure".
 
J

Joe Fallon

Can you import it as a Text field to a temp table first?
If so then you can write an append query to transform the text to Date/Time
and add the data to your real table.
 
Top