Results 1 to 7 of 7
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MSL to Access Transfer (Access 2000)

    Heres one for PR...
    Can you take data from a MSL database (Real Estate Software as I understand it), and transfer it to an Access Database proficiently? So far, the person in question I have found out has attempted to this, but because there is a Primary Key in her MSL database (and she doesn't know how to turn it off, I don't know, I have never seen this database before), it won't go into Access, and what does go in (evidently she's getting it there a little) breaks up into several tables instead of staying one table of transferred data...Anybody ever hear of an MSL database used by Realtors, and have any information for me on her getting the data into Access? Thanks for the feedback
    Nannette Padgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: MSL to Access Transfer (Access 2000)

    Hi Nannette,
    Are you sure it's MSL and not MLS? MLS is the Multi-Listing Service that most real estate agents use, and there are any number of databases from Informix to SQL Server to Oracle to, yep Access. The only way to know for sure is to find the file extension of the program she is trying to get data from. If it's Access, you could simply import objects into your own database, given they let you from a security perspective. In other cases, you may be able to attach to tables and work with them that way, and finally you can export to a format that Access understands - Excel, delimited text, etc, and then import into Access. Hope this helps.
    Wendell

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSL to Access Transfer (Access 2000)

    Wendell

    MLS, is the database, I'm sorry. This is a PR thing that Admin passed on to me from a phone conversation they had with Real Estate office in town, and I'm supposed to come up with a decisive, it can be done, it can't be done answer for them. I haven't got a clue of course, because I've never even heard of the MLS Database, and researching it online has not helped much this morning either. I know Access will Import many formats, DB, Excel, text, Lotus etc....but was curious if it would in fact recognize the MLS database and Import it easily enough or not. And if so, will she have to remove the Primary Key in the MLS Database first (If we can figure out how)? Or should it not be a problem to Import a preset key into Access. I always figured the Wizard would allow you to choose the key you wanted to begin with on way in, so didn't see why she was having a problem, but hey, thats the trouble with Imports, you never know what to expect. Have any other advice here on this Wendell, I'd surely appreciate any and all.
    Thanks NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: MSL to Access Transfer (Access 2000)

    If it's truly an Access database, then she should be able to import the whole table, indexes and all. So that suggests it probably isn't an Access table she's dealing with. If it were an Access query, and she tried to import it, that would get the query itself, not the results, and it surely wouldn't split things as you described it. My guess is that it's some other database, but that's a major challenge without touching the keyboard she's using! You might ask if there is some sort of splash screen that gives a different name - I suspect everyone just refers to it as the MLS database. If she starts it with a shortcut, you could have her read the path name to you and see if it's an MDB or MDE file. Not surefire, as a cute developer could change the suffix and still have it work, but unlikely. Good luck.
    Wendell

  5. #5
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSL to Access Transfer (Access 2000)

    Wendell,
    Are you saying that an MLS database could be an Access database in disguise? That MLS is just a fancy name on the User interface she's using? With maybe another name for it's Logo name? I'm a bit confused. Guess my question is simply: Can an MLS be a Microsoft Database in disguise? I will have Admin look into her extensions if need be, and then we will go from there, but if you could, answer the big question above first Wendell, I sure do appreciate this clarification.
    NMPadgett
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: MSL to Access Transfer (Access 2000)

    Nanette,
    Actually I suggesting that was the common name for it, just as you might have an Inventory database, or a Mailing Label database. And it could well be based on Access, though as I indicated, I suspect it is not. If the extension for the file is .MDB then it probably is, but otherwise . .. . . Sorry for the delay in responding - lunch got in the way.
    Wendell

  7. #7
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Jacksonville,NC, USA
    Posts
    705
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSL to Access Transfer (Access 2000)

    Wendell,
    Not a problem...you guys always hang in there with me, and ya' got to eat...[img]/forums/images/smilies/smile.gif[/img] I will do what I can to find out what the extension is, but doubt seriously it's an Access Database. Sounds like a Great little GUI program that Realtors use to save data in, and now one wants to "not" use it, and find a means of importing it into Access, why could be a number of reasons, lack of continued support for an application sold and used by the office maybe, or they may just have been introduced to Access and see its vast powers of those that be...thanks for sticking with me Wendell. As always I sooooo appreciate it.
    Nannette
    NMP <img src=/S/cool.gif border=0 alt=cool width=15 height=15>

    If you can't convince them, confuse them. - Harry Truman <img src=/S/scratch.gif border=0 alt=scratch width=25 height=29>

Posting Permissions

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