needing query info

[John]

I am relatively new to this part of A2k. I have done
simple queries but now I need to get down and dirty with
sending specific data from specific tables to excel
spreadsheets. The info can then be worked offline. Once
the spreadsheet is completed the info will need to go back
where it all came from. Some info will be new to the
table while other info is updating existing records. The
user may be "hitting the road" again and once they return
the spreadsheet info back to the tables, may turn right
around and resend the updated info back to excel.

Would this be working thru Excel, or thru Access, or both
to accomplish a task as this?

Does anyone know of websites, articles, etc. in which I
can read over information about this and get a good start
on making these types of queries.

Thanks in advance.
*** John

 

[James Goodman]

Have you looked into replication?
Based on what you describe, you need to allow users to edit/add data in a
disconnected envirnment. Access replication is excellent for this, &
requires little configuration.

If you search the help file you should find some helpful information...