Code to import filtered SQL server table to Access

[03Explorer]

I am struggling to find online help to use ADO coding to import a DSN established import from a SQL server table. I have code to import the full table, but that is too much data and I would like to have it filtered by a SQL statement before importing.
I have the connection string established, but can I have the import action create the table based on the source table or do I have to create the Access table (which I would have the table cleared before future imports and start fresh)...

Is there a good tutorial site or sample code that helps?

Thanx

 

[PHV]

Why not using a query based on a linked table ?
Or use an SQL server view ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[03Explorer]

Hmmm... maybe because when I open the linked table it sends Access into (Not Responding) mode for a long time... I guess I was hoping to import a small portion of each table (Nine total) making a local copy an easier and more managable size.

 

[Abdbod]

Mr O3Explorer could u please help me >>> I am searching for code how to import sql server table in to ms access by using vba
Thanks