Select Statement via DSN

[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

 

[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.