Showing posts with label datadata. Show all posts
Showing posts with label datadata. Show all posts

Wednesday, March 21, 2012

Importing from access with system Database

I am trying to import tables from my access database.

1st trying simple table, In ent mgr i right clicked the db folder
all task
import data
data source : Microsoft access
file name : c:\Data Management System\DMS.mdb
User name : mike (same used for lonin in access)
password : (same used for lonin in access)

advanced button:
jet Oledb: System database c:\Data Management System\Secured1.mdw

windows authentication
server (local)
database New -> dms

copy tables

now i see the items in my access database so i am guessing every step so far was correct

hey it worked !

ha,, hope u dont mind if i leave this here for anyone else, i ansd my own ?OK...but you know what's a pain...as soon as you join another group your DTS is HOSED...|||i dont get it what u mean join a group? dts hosage?