VBA coding to retrieve data from Access to Excel :S
- From: "Vicks" <w_man@xxxxxxxxxxx>
- Date: 27 Sep 2005 13:00:19 -0700
Hey everyone,
This is what i have so far. I have an excel workbook with 3
worksheets, SETUP, DATA and DISPLAY. I have been using a pre-coded
program to bring data from a database where the program using the SETUP
sheet from the excel workbook as its critaria and then populates the
DATA sheet. I then can use the DATA sheet to display data in the
DISPLAY sheet in which ever way i want.
Complication is that this pre-coded program is limited to the amount of
tables it can hit at a time. Basically its programmed to read up to 3
tables.
I now need data from 5 tables all together. The first three can come
from the pre-coded program. Now i need to use VBA to first go read the
data i want from the tables and then create fields/rows in the DATA
sheet . . obviously AFTER its done writing its columns/rows from the
pre-coded program (first 3 tables).
Im only having this problem because i cant see the code for this
'pre-coded' program . . otherwise i would have just seen how it was
done from there!!
ANY help would be appreciated . . .
Thanks in advance
~Vicks
.
- Follow-Ups:
- Re: VBA coding to retrieve data from Access to Excel :S
- From: michaelacumming
- Re: VBA coding to retrieve data from Access to Excel :S
- Prev by Date: Cell format requires manual edit
- Next by Date: Re: Cell format requires manual edit
- Previous by thread: Cell format requires manual edit
- Next by thread: Re: VBA coding to retrieve data from Access to Excel :S
- Index(es):
Relevant Pages
|
