Using ODBC Database in Append Query ?

[Luqman]

How can I use ODBC Database in Append Query.

For example, if I need to append data from dBase IV Table into Access Table
, I will run following query.

Insert in myAccTable Select * from [cust] in 'd:\luq' [dBase IV;]

But how to use ODBC Connection, defined as 'Fox' in ODBC Data Sources of
Windows Control Panel, in above query.

I tried following but could not succeed.

Insert in myAccTable Select * from [cust] in 'ODBC;Fox'

What am I missing please ?

Best Regards,

Luqman

 

[MGFoster]

How can I use ODBC Database in Append Query.

For example, if I need to append data from dBase IV Table into Access Table
, I will run following query.

Insert in myAccTable Select * from [cust] in 'd:\luq' [dBase IV;]

But how to use ODBC Connection, defined as 'Fox' in ODBC Data Sources of
Windows Control Panel, in above query.

I tried following but could not succeed.

Insert in myAccTable Select * from [cust] in 'ODBC;Fox'

What am I missing please ?

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

You can't designate a DSN (Data Source Name) in the IN clause of a FROM
clause. Microsoft recommends that instead of using FROM ... IN "..."
that you just link to the table you want to work w/ & use the linked
table name in your queries. See the TransferDatabase and TransferText
methods for examples of how to programmatically link tables/files to an
Access .mdb/e file.

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

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

iQA/AwUBQiYk0oechKqOuFEgEQK18ACfU6ow0RAU69pSeWKH1LK4O1aeunIAoOEQ
sNTxv85Hs/KvAO6xC0SKjvdn
=tEWe
-----END PGP SIGNATURE-----