Can SQL Server Version 9 Create an Access 2007 table

I have a potential client who says they are using SQL Server version 9.  It is not clear to me what version 9 means.  Is this a flavor of SQL Server 2008?

At any rate.  I am wonding if this version of SQL is capable of doing a query and tranlating the result set into an Access 2007 table.  Y/N

WoodrowAAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Aneesh RetnakaranConnect With a Mentor Database AdministratorCommented:
SQL 90 = SQL 9 = SQL 2005
SQL 100= SQL 10 = SQL 2008
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
>At any rate.  I am wonding if this version of SQL is capable of doing a query and tranlating the result set into an Access 2007 table.  Y/N

in order to populate the result t an MSAccess Table, u should create a linked server to the access database
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.