I have an SQL server 2008 R2.
From an MS Access db 2007 (on XP) i am trying to transfer a recordset that I got from the server into a lokal table. I cannot link the table because it gives me the wrong resultset - some numbers are gone!?)
With OPENROWSET I got a Jet problem.
I can of course insert it in a loop, but there must be a faster more pritty way to do it?