Hello, I've recently been asked to work with Microsoft Access, and
while I feel quite comfortable with Excel, I'm at a complete loss with
databases. If someone could help me with this issue I'm having I'd be
most appreciative. The database is already constructed, I'm just
wanting to export the data to an excel file.
In short, I'm hoping to export two Tables (or queries...not sure which
to use - they both seem to have the same data) in a Microsoft Access
database to a single blank worksheet (already created, lets call it:
'Data') in Microsoft Excel one right after another (order is
irrelevant). Let's call one of the Access tables: TCC, and the other
TCP.
The TCC and TCP tables have 5 and 6 columns respectively (although I
only wish the first 4 columns to be sent to the excel file), and have
similar titles (not exactly the same in all cases) but the contents of
each column is consistent with the ones on the other ( i.e. Column 4
on both are formatted as dates, column 3 contains numbers, column 2
contains text, and column 1 contains a name, but when I try to export
it to excel (not sure if I'm doing it right - I'm really clueless when
it comes to Access), I get an ID number. I would like if possible to
retain the name, as shown when viewing in the query, but this isn't a
life-or-death issue.
Now here is where it gets tricky:
I only wish for the entries whose dates (in the 4th column) are
between or include two dates on a different worksheet (called 'Entry
Form', located in the same excel file to be listed/pasted on the
'Data' worksheet. More specifically, cell C9 contains the beginning
date and C10 is the ending date. If/When one of these dates are
changed, I need the list of data exported from the two tables to be
updated. Also, I can't have any changes made to the excel file to
modify the data in the Access file. I'm not sure what other info you
may need, the dates in the 4th column for both TCC and TCP have a
field name of "Week Ending"
Thank you so much,
Stefan