Need help one a "complicated" problem
 

Hi all,

I'm currently trying to import data from Access to Excel. I have 10
huge databases and each of them represent a semester. I have no problem
getting them to Excel. However, afterwards, I have to compare them,
since I would have 10 worksheets, it would be very time consuming.

So, I was trying to find a way to put the information into a variable
(possibly and array?), compare them, sort them and then put them on the
worksheet. Anyone know how I might be able to do that?

Once again, I do not wish to get the data, put them on a worksheet and
then take the info from the worksheet again to compare them, because it
would take the program like 40 mins to run.


Thanks


Eric

Need help one a "complicated" problem
 

"cyc1120" wrote in message
oups.com...

Hi all,

I'm currently trying to import data from Access to Excel. I have 10
huge databases and each of them represent a semester. I have no problem
getting them to Excel. However, afterwards, I have to compare them,
since I would have 10 worksheets, it would be very time consuming.

So, I was trying to find a way to put the information into a variable
(possibly and array?), compare them, sort them and then put them on the
worksheet. Anyone know how I might be able to do that?

Once again, I do not wish to get the data, put them on a worksheet and
then take the info from the worksheet again to compare them, because it
would take the program like 40 mins to run.

Managing "huge databases" is more a mission for Access then
for Excel.
Why not using Access to do the job (comparison) to be
exported afterwards into Excel?

Bruno