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.
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.