Export to Access | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Export to Access

<br />The follwing is used to export sql server 2000 table to access<br /><br />INSERT INTO OPENDATASOURCE( <br /> ‘Microsoft.Jet.OLEDB.4.0’, ‘Data Source="D:Test.mdb"; <br />User ID=Admin<img src=’/community/emoticons/emotion-4.gif’ alt=’;P’ />assword=’)…SQL(no,n,x)<br />SELECT * FROM tt <br /><br />However it is required to create that table in Access. The above will export the data to access table. How can I modify the above to create table and export data?<br /><br />Madhivanan
I’m not sure about using CREATE TABLE in MS Access, you can try a query to create table before executing this query. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.