datas ms access to excel

I

inigo45

Hallo,
I have a certain amount of datas, which I put into MS Access. A part o
those datas should now AUTOMATICALLY forwarded (duplicated) to excel.
IE: In Access there is a row called item, the next is item number. Whe
I put those subjects into Access -the same rows are in Excel- shoul
duplicate it to Excel (item, item number).
What is the most convenient way to do this?
BTW I use MS Office 97.
Cheers
Juerge
 
B

BrianB

You have 2 basic alternatives :-

In Access - File/Save As .. Export.
In Excel - Data/Get External Dat
 
I

inigo45

Well, that's in order to paste the whole bunch of data. I want t
forward (duplicate) the data of row -lets say- 2 and 3. Row 1 and 3 t
7 are not forwarded to excel or access. It should do tha
automatically.
Cheers
Juerge
 
O

onedaywhen

The approach I'd use is to create an OUTER JOIN in SQL to find the
rows duplicated/missing from one source or the other.

However, you can't create any kind of JOIN between separate databases;
you will need to copy the entire table from one data source to the
other as a temporary table so that both tables are either in Excel or
MS Access. So the BrianB is right: you have 2 *basic* alternatives on
those basic choices.

So where are you more comfortable doing the comparison (i.e. JOIN):
Excel or MS Access? And do you want a solution that uses GUI tools or
VBA code? Also, please post some sample data.
 
I

inigo45

Hallo,

Actually the reason for the database is the image library. So I have t
entry the data incl. the images in the database, following the entry o
the same data (not all) in excel.

Data are in several rows, from which just two rows should be foun
subsequent in excel. Data are just plain text.
Most convenient would be
1. Input data in ms access (row 1 "name", row 2 "surname") (row
"consumption", row 4,.....),
2. similar an email proggy does, within excel I ask, if in the m
access database are new data and, if there are, download it to excel
In excel would row 3 "name", and row 4 "surname".

In this case I'd prefer GUI tools.

Cheers
Juerge
 
Top