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 />MadhivananI’m not sure about using CREATE TABLE in MS Access, you can try a query to create table before executing this query. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
]]>