use vbscript to create and execute the sql

set fso=createobject("scripting.filesystemobject")

set nfl = fso.createtextfile("c:\pathtoresultfile\resultfile.txt")

set fl= fso.OpenTextFile("c:\pathtofile1\file1.txt")

do while not fl.atendofstream

 nfl.writeline fl.readline

loop

set fl= fso.OpenTextFile("c:\pathtofile1\file2.txt")

do while not fl.atendofstream

 nfl.writeline fl.readline

loop

set fl= fso.OpenTextFile("c:\pathtofile1\file3.txt")

do while not fl.atendofstream

 nfl.writeline fl.readline

loop

nfl.close

set nfl=nothing

have "insert into invoices (customercode) values (@customercode)" as part of your stored procedure.

Set the invoice number to an autoincrementing field and set the default for the date to getdate()

Depending on...

Not sure I understand because your request says you want to find records where the accounid exists in both tables but then you say you want unmatched records.

To get unmatched...

update GE_Trans set TreatyID = substring(TreatyNumber, 6, 1)

run this after you add your new field to the table.  Also, I don't see why you would want to use a...

do you want a query to select the data or one to update the data or one to have the field always contain the data?

When you create your new field you can use substring(treatynumber,6,1) as a formula value.

I'm not sure what would happen if you were to change out the file for the one on your desktop.  You might want to try reinstalling the latest MDAC 2.8sp1. ...

If the admin share is there and you have access to it it would be \\server\c$ otherwise you will need to create a share to access. Security concious admins remove the...

I now have to recant my post about the sp being case sensitive.  I tested file location (server vs. client) at the same time and that was the piece that caused...

when I tested it on my server I got the same error but when I changed it to c:\test2.txt it gave me an error on the file Test.txt. I changed that...

the stored procedure is looking for it on the server's c drive when running through query analyzer.

it is case sensitive.  try c:\test2.txt

is there an e:\ drive on your pc with the excel file in it? 

when you run it manually it uses the dll on your client.  When it runs as a job it uses the dll on the server.  Make sure the dll exists...