importing ms access data into sql express

importing ms access data into sql express

• Jiri Lichtenberg

  Many thanks Mike, I'll check these out and it looks from a cursory examination this should be possible.
  

• CrazyAboutWPF

  Was this functionality incorrectly marked as included in SQL Express Edition then I believe the import/export wizards are part of SSIS which it is my understanding is not included in the Express Edition.
  
  It would be VERY useful to be able to import Access database data as I have a number of Access databases I'm trying to figure how to convert to the new SQL Express Edition. Is there any helpful documentation or tools available to convert this data
  
  Many thanks

  
  

• REspawn

  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.
  

• Roman Muller Interware

  SQL Express doesn't include Data Transformation Services, which is the tool that supports the Import/Export wizards. You have a couple options...
  
  - Use the Export functionality of Access. (File | Export) You'll need to have a DSN created for the database you want to send the data to.
  - Use the Access Upsizing wizard.
  - Export the data from Access into a text file and then use BCP to put the data into SQL.
  
  The first two will be documented in the Access help file, the thrid in Books Online.
  
  Hope this helps,
  Mike Wachal
  SQL Express Team

  
  
  

• CreggH

  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!
  
  

  
  

• S-cal

  Yes, the web page is incorrect; I’ve filed a change request to have the page updated.< xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

   

  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

  
  
  
• importing ms access data into sql express