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 |
|
axel
Starting Member
1 Post |
 Posted - 2005-12-07 : 10:17:09
|
| Hi there,I'm having trouble getting an import to work.Here what i want:i have created a dsn to extract data from an SQL2000 server into Excel. this all works fine. Now i have edited the data and would like to import the updated fields in my database.There are no new fields just updated information. I have used the import wizard from SQL Enterprise manager. I have selected to delete the current table and replace is with the one ive created.This is where the problems begin.When i finish the wizard i get an error saying there is a conflict "collum reference constraint". wich i think has something to do that there are links to this table wich can not be simply deleted and recreated.How do i get around this?Greets Axel |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-08 : 07:20:42
|
| Why not start afresh and recreate and export from scratchYou would have the old and the updated all togetherAfrika |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2005-12-08 : 07:22:20
|
| Opps sorryi think i have it the wrong way around ?sql to access ? |
|
|
|
|
|
|
Import Excel data doesn't work.