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?
Showing posts with label mgr. Show all posts
Showing posts with label mgr. Show all posts
Subscribe to:
Posts (Atom)