Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export fro sql query to an Access table

Status
Not open for further replies.

henin

MIS
Oct 30, 2007
35
IL
Hi everyone
From within Sql server i write a query:
Code:
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
 
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
 
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top