Post reply

link DBase tables

  • May 15, 2007 at 11:01 am

    #92584

    how can i link DBase tables into sqlsever?

    thanks

  • May 16, 2007 at 2:47 am

    #706699

    Import them with DTS

  • May 16, 2007 at 8:44 am

    #706826

    If the dBase tables are part of an actual DOS-era dBase application, then importing is your only safe option.

    Even thought dBase is 100% Y2K-compliant within its own environment, there's a LastUpdate field in the table header that is not. If you attempt to write to a DBF after 1/1/2001 from another application, it will place an invalid value in the header, and dBase will not be able to recognize the table. If that happens, you would need to use a disk editor to fix the header. Learned that the hard way.

     

  • May 16, 2007 at 12:09 pm

    #706911

    in case of dbase what are the parameters for the sp_addlinkedserver command?

  • May 16, 2007 at 12:47 pm

    #706923

    Here is a good discussion thread, maybe this will help:

    http://www.dbforums.com/showthread.php?t=903076

     

  • May 17, 2007 at 4:00 am

    #707046

    Check advantage database local server (free). U can link to dBase tables by creating Advantage database definition and update /query dBase/Clipper tables with sql. They provide oledb driver. Theoretically should work

  • May 17, 2007 at 5:07 am

    #707068

    checked also practically. Works

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply