June 3rd, 2004, 01:02 AM
|
|
Registered User
|
|
Join Date: Jun 2004
Posts: 1
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
How to retrieve data from Excel by using VBA
Halo, im a newbie 2 both VBA and Excel, I was assigned to design a VBA script which can post various query to retrieve data from multiple excel sheets with same attributes but different data( one at a time )...linking by using ODBC...
Here is an example of my requirements...
Lets said I post a query, Select all employee from emp1 where sex = female and age > 20, and the VBA will retrieve the data from excel and show the result which match the query...so can any1 provide a simple example wif
(i) a simple excel file with data...
(ii) VBA wif the simple query...
I jus know this can b done by a Java program with a linking to access by ODBC....
pls...tis is urgent, any1 can help??
pls help me bout tat....thankz (^_9)
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
