I am trying to append records from one SQL Server table to another, with both tables having the same structure and the receiving table being empty and the primary key in the receiving set to 0 and not appending the primary key from the source table.
I get "overflow" with no other information. Any ideas where I should look?
Appending from 1 SQL Server table to another with overflow
-
kwvh
- 3StarLounger
- Posts: 308
- Joined: 24 Feb 2010, 13:41
-
Wendell
- 4StarLounger
- Posts: 482
- Joined: 24 Jan 2010, 15:02
- Location: Colorado, USA
Re: Appending from 1 SQL Server table to another with overfl
The receiving table should not have a primary key if you are setting it to zero - are you doing the append from Access using queries, or running the query in SQL Server?
Wendell
You can't see the view if you don't climb the mountain!
You can't see the view if you don't climb the mountain!