Post reply

import/export problem

  • February 7, 2007 at 10:00 pm

    #175904

    In SQL2000, when I do import/export, there is DBaseV in the destination. In

    SQL 2005, there is such selection. How can I make DBaseV export in SQL 2005?

    Thanks.

  • February 7, 2007 at 10:25 pm

    #688455

    Sorry.  I mean in SQL 2005, there is no such selection at all.

  • February 7, 2007 at 11:29 pm

    #688457

    For some reason they removed...no idea why... you may try exporting into excel and convert excel into dbase/faxpro...

    Just google for "excel to dbase convertion"

    MohammedU
    Microsoft SQL Server MVP

  • February 8, 2007 at 5:22 pm

    #688710

    There is a dbt file when doing import/export in sql2000 which I need. But if I do it with excel, then the dbt file cannot be generated. PLease help. Thanks.

  • February 9, 2007 at 11:46 am

    #688937

    The import/export wizard doesn't support DBase files, but Integration Services does. You can export to dbase files using the OLEDB provider for Jet 4.0 in SSIS.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

Viewing 5 posts - 1 through 4 (of 4 total)

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