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
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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.