Heh... it's always an option if the nail in the bat is large enough and you can find the designers that put...

Dumb question... are you trying to test the code while the spreadsheet is open? If so, BOOOM! You'll get the error you got.

What's are the common columns between the two tables? Gotta have something to join on to start with.

Recommend you post the schema for both tables...

Perfect... thanks for taking the time to post your feedback!

Thanks for the feedback, Chris... glad it helped.

The Nirvana that you hint about. This is only likely to exist when all IT systems are in a constant state of renewel, and there is no legacy to deal...

Heh... worse... RBAR on steriods over the "pipe".

Heh... lemme say it again...

Heh... thanks... good to know.

And, my bad... didn't look at the first post... this is Oracle code...

Because in a proper mixed format fixed field data set, each row will have a "rowtype" marker. Mixing header information in the data will frequently cause bulk loads to...

Sure, Praveen... I just said that 😉 but thanks for the feedback.

And, my bad... Ramesh was the one that said it needed to be done without a temp table and...

Adrian is correct,

Anything that looks like a numeric entry, will be treated like one by Excel. If you type 000123 into Excel, it will be changed to 123 by...

One might also try posting the original question on an Access forum... I do very little in Access and don't know the answer other than running the script you originally...

I guess I don't understand... why does the addition of columns to tables in ACCESS have to be automated to begin with?

If we had found a solution for you, everyone would benefit because we would post the answer. To be courteous, you should too...