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

"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