VBA code to import table via query

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?
 
T

Tom van Stiphout

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to export table from outlook into ms access table? 0
Access Table Import with VBA 2
Import crosstab query as a table using code 4
Import Query as Table 7
Get records with a negative value anywhere in the table. 8
VBA code importe txt file 2
Insert Into? 0
Access Import & Link section grayed out MS Access 2010 1

Top