Need to run a sql statement against a sybase from ms access

[Ken]

I need to run a sql query against a Sybase database periodically from Access
2007. I have an ODBC entry for the Server and database. Can someone point me
to the documentation on how to do that?

Thanks

 

[Klatuu]

Link to the table or tables you need to use in the Sybase databse using your
ODBC connection. Then you can use a query written in Access to query the
data.

 

[Larry Linson]

. . . you can use a query written in Access to
query the data.

because the ODBC driver for the Sybase database will do the necessary
translation for you. On the other hand, if the SQL statement you have is
written in the "Sybase dialect" of SQL, you can use a Passthrough Query to
tell Jet/ACE and ODBC to "keep your cotton-pickin hands off my Query" and
run that, instead.

Larry Linson
Microsoft Office Access MVP