Great minds think alike  Well mine isn't that great.  One more question if you don't mind.  Is it possible to import a file from another machine on my network?  When I
run the query it pulls the text file off the local computer.  I need it to pull off of another machine on the network.  Is this even remotely plausible?

Ignore my last post...sometimes I type before I think...all I have to do is map a network drive to where the file is located...

Just one little thing, Andy - you wrote :

UPDATE invoice
SET Number=table_temp.Number, Shipping=table_temp.Shipping,
TrackNum=table_temp.TrackNum
FROM invoice JOIN table_temp
ON table_temp.number=invoice.number

but you don't need:

SET Number=table_temp.Number,

since your JOIN is:

ON table_temp.number=invoice.number

not particularly important here, but it just popped out the screen at me so
I thought I'd mention it...

--
Chris
(XP-Pro + Delphi 7 Architect + DBISAM 4.25 build 3 + EDB 1.00 build 6)

Thanks for that, I will make the change.  Can I add an IF statement to the IMPORT statement?  One of the problems I am now having is sometimes we have multiple
boxes with different tracking numbers using the same invoice number.  When I run the statement is gives me a duplicate key error.  How can I tell it to only import one of
the numbers instead of all of them?

Andy,

<< When I run the statement is gives me a duplicate key error.  How can I
tell it to only import one of the numbers instead of all of them? >>

Unfortunately, no.  You'll have to pre-process the import file to remove any
duplicates first.

--
Tim Young
Elevate Software
www.elevatesoft.com