Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations MikeeOK on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access--->sql using dts (data only no table structure)

Status
Not open for further replies.

ktucci

Programmer
Apr 23, 2001
146
US
i need to copy data(just data not the table structure) from 55 tables in an access database to 55 pre-existing tables in SQL Server 7...i tried using DTS with no luck...i want to do the whole transfer in one package...any help will be greatly appreciated
 
You should be able to use DTS. We are able to use it with no problem. DTS is probably the best way to transfer data from Access to SQL Server.

What do you mean by "no luck"? Can you provide a specific error message or problem you encountered. Terry
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top