10-10-02, 08:32 #1Registered User
- Join Date
- Jun 2002
Unanswered: access export in sql wrong schema
I'm trying to export an table from access to sql2000 - SR1 / w2k
using an sql user ("Adm" let's say..) wich creates tables under .dbo schema (is in db owners role); ok, but when I export it from access
, the exported table appears under "Adm" schema instead "dbo" schema...
try and see if I'm wrong.