Question about OPENDATASOURCE | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Question about OPENDATASOURCE

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
http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=7850
Madhivanan Failing to plan is Planning to fail
]]>