Home |
Search |
Today's Posts |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
Problem: Worksheets("New Style 2006").Unprotect Password:="naPrint" | Excel Programming | |||
Problem with "On error resume next" with "custom VLookup" | Excel Programming |