Importing!

[Dan]

I hope this is easy for one of you experts!!! I need to
import data into a table that already exists. Sounds
easy but I have date/time fields that botch up the
process. Any advice?

Thanks!

Dan

 

[John Nurick]

Hi Dan,

The trick is to link or import the data to a temporary table, and then use
an append query to move it into your existing table. Use calculated fields
in the query to sort out the date/time fields as you go. If you need help on
that, post back with more information about the date/time formats in the
imported data.