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

  • Thread starter Thread starter Ken
  • Start date Start date
K

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
 
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.
 
Klatuu said:
. . . you can use a query written in Access to
query the data.
Click to expand...

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
 
Back
Top