Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003

    Unanswered: 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 ?

  2. #2
    Join Date
    Nov 2002
    OK...but you know what's a soon as you join another group your DTS is HOSED....

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Oct 2003
    i dont get it what u mean join a group? dts hosage?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts