ipisors (7/30/2014)
Craig, that looks like the same solution/examples I already had.So you're passing values explicitly in the sql insert. I know how to do that.
I have 14,000 values in my MS ACCESS table. Am I to execute that code 14,000 times, changing the explcit values each time?
Shouldn't have to. It's just an example to show mechanism.
IDENTITY_INSERT ON
INSERT INTO (IDCol, ColA, ColB)
SELECT
IDCol, ColA, ColB
FROM
AccessTbl
Should work just fine. How are you SELECT *'ing your Access table currently from SQL? That's the hardest part.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA