Update imported data

G

Guido Franzke

Hello,
I have imported data into a new table from another SQL-database via ODBC
databases and DSN.
Is it possible to reread the data from the extern database automatically or
do I have to import all external data again and again? Is it possible to do
it automatically with a querie or so?

Thanks for help,
Guido Franzke
 
M

MGFoster

Guido said:
Hello,
I have imported data into a new table from another SQL-database via ODBC
databases and DSN.
Is it possible to reread the data from the extern database automatically or
do I have to import all external data again and again? Is it possible to do
it automatically with a querie or so?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Just link to the external table(s).

- From the menu bar select File > Get External Data > Link.
Select ODBC in the Files of Type Combo Box on the Link file navigation
dialog box.
Select the DSN from the Select Data Source dialog box.
Select the table(s) from the Table/View selection dialog box.

When you've successfully linked to the table(s) you can write queries to
read those table(s) data.

You can also use SQL Pass Through (SPT) queries. Read the Access help
for more info.
--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

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

iQA/AwUBQw4OC4echKqOuFEgEQIHdwCgi5ec/dn61atOFHOKDu7MJMDLP4MAoMwc
arnFOllidhzZBquTrP/3/Fat
=L7WM
-----END PGP SIGNATURE-----
 
Top