Does anyone know how to use the Data Transformation Services(DTS) in Access 97? They say you can use it to transfer data from one database to another.
Thanks.
Printable View
Does anyone know how to use the Data Transformation Services(DTS) in Access 97? They say you can use it to transfer data from one database to another.
Thanks.
Using Enterprise Manager. Select Import or Export depends on your case and then you can select a type of transfer, such as SQL Server, text files, Access, etc.