Getting remote SQL data into my Access report

[Rich Mogy]

I am trying to get information into my Access report from a remote SQL 7
database. I am currently bringing this data into an Excel spreadsheet and
then linking the excel spreadsheet as an Access table, which seems
convoluted to me.

Is there a way to directly query my SQL database (I read about SQL
passthrough, but don't know how to save this information for my report to
read

Or am I complicating this too much? Any help would be appreciated.

Rich Mogy

 

[Duane Hookom]

Have you set up an ODBC/DSN that points to your SQL 7 database? Creating a
pass-through query is fairly easy if you can select a DSN. Once you have
defined this and possibly entered your User ID and Password, you can enter a
SQL statement to retrieve records. Use the p-t as the record source for your
report.