Haven't done programming for a while-rusty now. Need help from any of you:
1) Trying to retrive data from SQL server to Excel by VBA. The SQL database
is huge, which has over 50,000 data in it. But only 2 columns have index. For
example, I want to output all the employee's name whose salary is below
10,000, and the group between 10,000 and 20,000, while the salary does not
have index, but employee's name has index. As the database is huge, it takes
forever to get the data. Anyone has idea to improve the speed? Or any
alternative?

2) trying to run the macro and retrive some data into Excel sheet for
selection. For example, I have 1000 employee use the bank HSBC, and another
2000 people use Whacovia. How can I get only one HSBC and one Whavocia into
Excel cell for a selection?

Thank you very much and appreciate your ideas.

When you say "over 50,000 data", do you mean "over 50,000 rows"?
That's nowhere near being a "huge" database, so if performance is
unacceptable there must be serious problems with the design (or
maybe it's just hosted on inadequate hardware).

For the types of data extraction you mention I would have thought
that MS Query would be a suitable tool for getting the data into
Excel.

Andrew

NiNi wrote:
Haven't done programming for a while-rusty now. Need help from any of you:
1) Trying to retrive data from SQL server to Excel by VBA. The SQL database
is huge, which has over 50,000 data in it. But only 2 columns have index. For
example, I want to output all the employee's name whose salary is below
10,000, and the group between 10,000 and 20,000, while the salary does not
have index, but employee's name has index. As the database is huge, it takes
forever to get the data. Anyone has idea to improve the speed? Or any
alternative?

2) trying to run the macro and retrive some data into Excel sheet for
selection. For example, I have 1000 employee use the bank HSBC, and another
2000 people use Whacovia. How can I get only one HSBC and one Whavocia into
Excel cell for a selection?

Thank you very much and appreciate your ideas.