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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to have two tables on same line? 1
import an Excel file to create a Gantt chart in Visio; Error:do not have the required mapped columns 0
Type Conversion Failure importing number as text 1
Importing date problems in CSV 1
Import CSV Type Conversion Failure 3
Losing long numbers regardless of format 2
HTML Import not parsing properly when using VB or macro 1
why "Type Conversion Failure" import EXCEL into ACESS TEXT field 1

Top