Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
happycloud
Starting Member
3 Posts |
 Posted - 2001-11-09 : 16:43:09
|
| Hello out there!!! I am trying to import data from a table in Access to one in MS/SQL 7.0. The first time I created a DTS package to import the data it was wonderful. BUT, now I have new data in the Access table that I need to have imported to SQL. How can I import only the new data without creating duplicates or overwriting the current data that is in SQL? I want to append the new data only. I tried writing a query but keep running into problems. The fields I want to import are: File_Name, File_Data_Name, Format and Data_Name. Both tables in Access and SQL are named filesdata. This is going to be an ongoing process that I will have to do so I am wanting to do this correctly the first time and be able to run a job later. Thanks for any help :) |
|
|
|
|
|
Importing data from access to SQL