Importing!

  • Thread starter Thread starter Dan
  • Start date Start date
D

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