Question about OPENDATASOURCE | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


I am using OPENDATASOURCE to transfer data from SQL to Access. Once data is transfered, the access file stays open. Is there a command that closes the Access file that should be executed after OPENDATASOURCE?<br /><br />code:<br />INSERT INTO OPENDATASOURCE<br />( ‘Microsoft.Jet.OLEDB.4.0′,’Data Source="C:Test"; User ID=Admin<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />assword=’ ) … Activity( ActivityID)<br />SELECT ActivityID FROM Activity<br /><br />Thanks,<br />Martin
As an alternatice, try openRowSet
Madhivanan Failing to plan is Planning to fail