update/append query

  • Thread starter Thread starter JohnE
  • Start date Start date
J

JohnE

I am a relatively new to this part of A2k. I have done
simple queries but now I need to send specific data from
specific tables to excel spreadsheets. The info can then
be worked on 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.

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 to anyone responding.
*** John
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

You should re-think this strategy. When you take the data out of its
controlling space (the database) there is the possibility of the data
integrity being broken. IOW, when the data is in the Excel s/s the
user could put a string in a numeric column, or vice-versa. When you
try to re-import the data to the database you'll get an error. Also,
the user may try to enter unrelated data to a column that acts as a
Foreign Key to another table - Excel won't be able to enforce data
integrity.

Read about Replication in the Access Help articles. Replication
allows you to create a copy of the database (full or partial) that the
user can carry around in a lap top and make changes to the data that
will be controlled by the original db's data integrity rules. The
master db can be updated using the master/replication synchronization.

If you're really set on your first idea read the Access Help articles
on TransferSpreadsheet. You can also export a query by highlighting
the query in question & on the main menu bar clicking: File > Export
.... then follow the directions in the following dialog boxes.

To import data from an Excel s/s use TransferSpreadsheet, again, & put
the data into a temp table. Then write queries & VBA procedures to
validate the data & transfer it from the temp table to pertinent
production tables.

MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQCQU44echKqOuFEgEQKppACg7J3BAdD+lDG3n1zBHTQFtP2OMykAoNiA
zm1fiD9b7Yngi8PC7mM9Lofg
=efqm
-----END PGP SIGNATURE-----
 
Back
Top