Exporting data from Access

[addon_noe]

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

 

[Smart]

Yep you can import data only using the DTS wizard
You can import tabvles buy creating and deleting them from the server before copying them over or you can append the data overor you can copy and replace data (the method i Prefer) see attachement