Thanks, Paul.

That's actually what I've started to think about this afternoon, and discuss
with the Ops manager... questions to him about whether he wants to archive
the load data, or do a full replace on the Access table each time it's
updated.

Thanks for the suggestion. It should work.

Mark

"Paul V.S." wrote:

Hi Mark...I had very similar issues and what I did what link in the Oracle
database to access and import the spreadsheet files to access....run an
append query to a flat table and use excel to pivot off of that table....

If these users are good at excel, they'll have no problem picking up the
Access piece (not talking about heavy access programming).

Paul


"mark" wrote:

Your IT Dept surely has a utility or process to handle the upload.


The Ops department is very proficient in Excel, and would want to be doing
lots of "what-if" analysis... repeatedly.

As of yet, we haven't opened up the database for write access, to end users,
directly. I could write the whole thing in Excel, or PL/SQL, but without
direct write access to the database from Excel, it wouldn't be as seamless
and flexible as desired.

That was the reason for my query.

If it were possible to combine two ADO recordsets and apply the result to a
Pivot Cache, or an ADO recordset and an array, or something like that... that
would give the users the flexibility they're looking for, without going
through changing IT management's viewpoint on database security.




thanks.