Hai,

Check whether this works. In DTS select Microsoft OLE DB provider for oracle

and enter the Oracle DB name, Password and assign permissions or using ODBC connection

for ORACLE.

Hai ,

Using DTS import the table into the SQL server. In DTS mention source as MS ACCESS

and Target as SQL SERVER and select the DB which u want to..

Did I answer...