Access 2007 and SQL2008 upsizing issue...

[ChrisD]

I am trying to upsize an access table to SQL server 2008 using a system DSN
connection. It tells me that: The Upsizing Wizard works with Microsoft SQL
Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data
source. I have all the office updates available and this is not SQL
Express...Any thoughts on why I might be seeing this?

Thanks in advance...

[a***@gmail.com]

uh why are you using a BETA version of SQL Server?

Why don't you try this with SQL 2000 or SQL 2005 first?

Seriously here!!!

Post by ChrisD
I am trying to upsize an access table to SQL server 2008 using a system DSN
connection.  It tells me that:  The Upsizing Wizard works with Microsoft SQL
Server (Versions 6.50 SP5 or higher).  Please log in to a SQL Server data
source.  I have all the office updates available and this is not SQL
Express...Any thoughts on why I might be seeing this?  
Thanks in advance...

[Andy]

I tried upsizing from Access 2007 to Sql Server 2008 RC0 and also got the
same result. However, I was successful in upsizing from Access 2007 to Sql
Server 2005 Express, and also successful in importing from Access 2007 to Sql
Server 2008 RC0 using the SQl 2008 Import utility.

Sounds like you'll have to wait for a SP for Access 2007, so that it knows
how to look for SQL 2008 databases.

Post by ChrisD
I am trying to upsize an access table to SQL server 2008 using a system DSN
connection. It tells me that: The Upsizing Wizard works with Microsoft SQL
Server (Versions 6.50 SP5 or higher). Please log in to a SQL Server data
source. I have all the office updates available and this is not SQL
Express...Any thoughts on why I might be seeing this?
Thanks in advance...