Select Statement via DSN

T

taccea

How do I run a SQL select statement via the DoCmd.Run SQL method/action
through a DSN to a SQL2000 database to make 3 Access2000 tables.

ThankYou

Taccea
 
D

Douglas J. Steele

Easiest way would be to create a linked table that uses the DSN, or a
pass-through query that uses it. You would then base your make-table queries
on that linked table or pass-through query.
 
Top