Using ADP to export query/view to Excel

[Guest]

I am using ADO connection from ADP, connecting to SQL Server. I would like
to select records from the SQL Server and then export them to a Excel file.
I have done this in a regular MDB but don't know how in using ADO and SQL
Server to achieve the the same result. Can anyone help?

 

[Sylvain Lafontaine]

If you are using linked tables (with or without associated Views on the
SQL-Server side); the procedure will be exactly the same.

You don't tell us the method you are currently using for exporting your data
to Excel, so it's hard to give you more information or other options.

S. L.