Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2007
    Posts
    2

    Unanswered: Export data from SQL Server 2005 Express to Access Database?

    I have to export data from SQL Server 2005 express to Access database. I have done many import/export using DTS package via SQL 2000. I don't have BI installed in my SQL SERVER 2005 Express. I understand that I have to use SSIS for sql server 2005. Any help is greatly appreciated.

  2. #2
    Join Date
    Aug 2007
    Posts
    2
    Exports SQL Server 2005 database to Access database. We used BI studio export data from each table in SQL SERVER Express to Flat files.txt then import to Access database. Reason being that the Unicode was the issue with Access database.

    We have successfully completed the project for the programmer in our team. Life was good.

    Someone told me that I can use SQL Server 2000 instance to export SQL Server 2005.

    I tried and cannot be done. Instance in SQL Server 2000 can't find instance in SQL 2005 Express.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •