Import HTML table date field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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".
 
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.
 
Back
Top