VBA code to import table via query

  • Thread starter Thread starter Sheldon
  • Start date Start date
S

Sheldon

Hello -

I need VBA code for MS Access to import a table using an ODBC datasource
(DNS). I need to import the table with a basic query of Select * from
TableName Where DateOfService = Today - 1. I need it to arrive in the MS
Access database as a table.

If this is possible, can anyone send me the code or point me in the right
direction of where to get the information?
 
On Tue, 21 Oct 2008 18:54:01 -0700, Sheldon

Create a linked table for the ODBC table. Then read in the help file
about MakeTable queries.

-Tom.
Microsoft Access MVP
 
Back
Top