importing ms access data into sql express

Why then does the document

SQL Server 2005 Features Comparison
Published: November 7, 2005
http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

explicity say under the section "Integration and Interoperability"
that the Express Edition supports "Import/Export"
the sames as Workgroup, Standard and Enterprise without any qualification!

?

Timbo at 2007-10-6 >

Yes, the web page is incorrect; I’ve filed a change request to have the page updated.

If your goal is to get Access data into SQL, you can actually do that just as easily, maybe even more easily, from the Access side. Access supports both export of data to SQL Server and a tool called the Upsizing Wizard that does a lot more than just move data in an effort to help you migrate your Access application from using Jet data to using SQL data. There are a number of white papers on the Microsoft web site that discuss this migration from several different angles. I’d suggest starting at http://www.microsoft.com/sql/solutions/ssm/access/accessmigration.mspx and working though the papers on that site.

The papers are still referencing SQL 2000, but the concepts still apply to SQL 2005.

Regards,

Mike

MikeWachal-MSFT at 2007-10-6 >

Timbo wrote:

Why then does the document SQL Server 2005 Features Comparison Published: November 7, 2005 http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx explicity say under the section "Integration and Interoperability" that the Express Edition supports "Import/Export" the sames as Workgroup, Standard and Enterprise without any qualification! ?

The web page now shows no check mark for the Import/Export. So must mean that the express product does not support this option.

LarryGatlin at 2007-10-6 >