Yes the Update is what I have been using. It was part of the original stuff I copied and it's purpose according to the author was to get it to...

I had forgotten that I had continueonupdateerror=true in there so I turned that off and maybe now we can see the issue. I tried it and quickly got this error:

System.InvalidOperationException:...

Looked at the profiler, lots of stuff going on in there with my web pages I had not realized. Anyway, I saw repeated rows of BatchStarting and BatchCompleted with some...

When I add the NULL part I get this:

The multi-part identifier "meter_data_tablev2.meter_data_dmd_time" could not be bound.

I tried both REAL names for Access and SQL and get the same error. When...

Okay, I've done so many different things I'm starting to get myself confused so let me make sure I have it down.

here is my select command with the join:

select [sqlaliasname].meter_data_dmd_time,...

Still getting: Ambiguous column name 'meter_data_dmd_time'.

Ambiguous column name 'meter_data1'.

Ambiguous column name 'Station'.

Ambiguous column name 'meter_data_meter_id'.

I'm not sure what to think. It seems to me like the joining is being...

Well I tried a few different things a few different ways. I'm probably not doing this correctly but my confusion is in what to "call" the table from the data...

I will give that a shot and let you know. It probably won't be until tomorrow though. By using "someone else's" code I don't fully understand it, but at first...

I pasted the code above and most of it is still the same. I added a progress bar and a few other things, but for the most part I am...

No, I'm sorry, I must have not stated this correctly. I have an Excel sheet using VBA that already does what I need it to do. However, it exposes too...

Excel allowed me to export the data from the Access DB into SQL. The Access DB is actually not a real Access DB that was created with Access. It is...

OKAY! Second poster "Cold Coffee" was on the right track and I made one mod which made it work.

You had avg(meter_data1) so I changed that to SUM(Meter_Data1)/4 and that got...

Let me provide you with more data. If I run your statement against all the data as you left it, I only get one result for multiple hours. Each hour...

Absolutely right, I will never know for sure! Okay, I am pasting what I HOPE is correct below based on your well written (by the way) etiquette page. The data...

Based on your forum etiquette I did a hack job on this post so I deleted what was in here and will post again in a bit when I get...