Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Can i use access database as Source for scribe software. RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi all,

      Can i use access database as Source for scribe software.
      If yes/ not---?what should i follow to migrate data from Access database to crm.
      We already installed scribe on our machine..and documented migration requirements.
       please reply me immediately. It's urgent.

    Thanks in advance,
    Natarajan.V
    Monday, October 26, 2009 10:39 AM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Natarajan.

    It seems that your choice is ODBC Data Sources - you can add you database there.
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Monday, October 26, 2009 11:58 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    You link to a table in the Access DB using ODBC and then you create a mapping from the source (Access table) to the target (CRM). If you have multiple tables you create multiple mappings.

    A more detailed response would require a detailed knowledge of the Access tables in question. It is like asking what the procedure is for passing data from Excel to CRM; you link and map them and press the button.

    Scribe is quite a complex program for a novice user, you may want to google around for documentation regarding the basics.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Monday, October 26, 2009 12:42 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    You should be able to access the Access tables through the standard Microsoft connectors (OLE DB and the like). It is then a case of setting up the mapping in Scribe.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    • Proposed as answer by Leon TribeMVP Monday, October 26, 2009 11:28 AM
    Monday, October 26, 2009 11:28 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Leon,

         In our scribe source connect link,we are not able to find OLE DB link.

         i am able to find following links only.

         1.Adapters
         2.Native databases
         3.ODBC Data Sources
         4.Text files
         5.Xml

    What should i follow to migrate data from access to crm.
    please reply me immediately.it's urgent for me.



    Thanks in advance
    Natarajan.V
    Monday, October 26, 2009 11:54 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi, Natarajan.

    It seems that your choice is ODBC Data Sources - you can add you database there.
    Truth is opened the prepared mind My blog - http://a33ik.blogspot.com
    Monday, October 26, 2009 11:58 AM
    Moderator
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Andriy,

        Can i connect Access database using ODBC Datasources link.
        what is the procedure to migrate data from access to crm.
       We already installed scribe on our machine..and documented migration requirements.

        Please reply with steps,i will follow for migration.

        for eg: i have added field new_testfield to CRM account form,which is availabe in the  Company Access table Company testfield.
        what will follow to migrate all the data form access compnay table to CRM account form.

       
       please reply me immediately. It's urgent.
    Natarajan.V
    Monday, October 26, 2009 12:20 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    You link to a table in the Access DB using ODBC and then you create a mapping from the source (Access table) to the target (CRM). If you have multiple tables you create multiple mappings.

    A more detailed response would require a detailed knowledge of the Access tables in question. It is like asking what the procedure is for passing data from Excel to CRM; you link and map them and press the button.

    Scribe is quite a complex program for a novice user, you may want to google around for documentation regarding the basics.

    Leon Tribe

    Want to hear me talk about all things CRM? Check out my blog

    http://leontribe.blogspot.com/

    or hear me tweet @leontribe
    Want to hear me talk about all things CRM? Check out my blog http://leontribe.blogspot.com/ or hear me tweet @leontribe
    Monday, October 26, 2009 12:42 PM