Hi, I'm just wondering is there a way to export the data from Access to Sql Server?
The tables are already created in Sql Server so all I would need to do is to import the data from the tables of Access into the tables of SQL Server.
I believe with DTS wizard they create both the tables and the data. Does anyone know if DTS can also just migrate data only?
Thanks
The tables are already created in Sql Server so all I would need to do is to import the data from the tables of Access into the tables of SQL Server.
I believe with DTS wizard they create both the tables and the data. Does anyone know if DTS can also just migrate data only?
Thanks