Export fro sql query to an Access table

[henin]

Hi everyone
From within Sql server i write a query:

SELECT myName
FROM
namesTable

I want its result exported to an Access table (or sheet, or "page" I dont know Access, i only want data to be exported there). Can anyone help me with that ?
Thanks

 

[bborissov]

Why not do this inside the Access?
But you should ask in Access form for this.
I am not so familiar with Access to help you here :-(

Borislav Borissov
VFP9 SP1, SQL Server 2000/2005.
Microsoft MVP VFP

 

[TRBLUE]

Open up Access and create new database and do right click and open up linked database, and use the odbc and your have the table in access . Look up linked databases.

 

[henin]

Thanks..