K
Kayda
I need to use Access a little like an ETL tool, and want to run a
macro that imports data from an ODBC source (Sybase in this case) and
then uses insert and update queries in Access for manipulation. The
macro will be scheduled using the Windows Scheduler.
Anyway, I am trying to use the "Transfer Database" action in the
macro. The only thing I don't understand, is how do I keep from
importing the entire table from Sybase, i.e. I want to import using a
query, looking at the Access database, getting a maximum existing date
and then just importing anything newer than that. The Sybase db is a
closed system, I only have read access to the tables so running a
Sybase stored procedure is out of the question--I just want to pass an
SQL Query instead of just specifying the entire table for import.
So:
1. How to use a query to import data from an ODBC source by specifying
that query in Access.
2. How to get a date from an Access table and pass that to the WHERE
clause in my Sybase ODBC query?
Thanks,
Kayda
macro that imports data from an ODBC source (Sybase in this case) and
then uses insert and update queries in Access for manipulation. The
macro will be scheduled using the Windows Scheduler.
Anyway, I am trying to use the "Transfer Database" action in the
macro. The only thing I don't understand, is how do I keep from
importing the entire table from Sybase, i.e. I want to import using a
query, looking at the Access database, getting a maximum existing date
and then just importing anything newer than that. The Sybase db is a
closed system, I only have read access to the tables so running a
Sybase stored procedure is out of the question--I just want to pass an
SQL Query instead of just specifying the entire table for import.
So:
1. How to use a query to import data from an ODBC source by specifying
that query in Access.
2. How to get a date from an Access table and pass that to the WHERE
clause in my Sybase ODBC query?
Thanks,
Kayda