I tried this stattement but it gave following error
INSERT INTO OPENDATASOURCE(
'Microsoft.Jet.OLEDB.4.0','Data Source="D:\Test.mdb";
User ID=Admin;Password='
)... AccesstableName(col1,col2,col3,...coln) SELECT col1,col2,col3,...coln FROM SQLServerTableName
Server: Msg 7399, Level 16, State 1, Line 1
OLE...