promotion image of download ymail app
Promoted

convert txt file into dbf file?

i want to convert txt file (text file) into dbf format. suggest any software.

4 Answers

Relevance
  • 1 decade ago
    Favorite Answer

    1. Import to SQL server using DTS and again export to .DBF agains using DTS wizard.

    2. You could use BCP utility. it's fast and quite simple. Check BOL for more details.

    DECLARE @bcpCommand varchar(255)

    , @RC int

    SELECT @bcpCommand = 'bcp db_name.dbo.table_name in "' + @aFileName + '" -c -t, -S SERVER_NAME -T'

    EXEC @RC = master.dbo.xp_cmdshell @bcpCommand, no_output

    3. If you use or can take a few moments to learn Python, there are python

    utilities to read/write DBF files. www.python.org and

    www.vex.net/parnassus would be good starting points.

    • Commenter avatarLogin to reply the answers
  • 3 years ago

    Dbf Python

    • Commenter avatarLogin to reply the answers
  • 4 years ago

    It depends on which version of office you are using. MS Office 2007 has a full utility for converting and editing PDF files.

    • Commenter avatarLogin to reply the answers
  • 1 decade ago

    1.Search in yahoo/google for word/text to.dbf programs

    2.If you have a copy of dbase,

    First create the file structure

    create (file)

    then append your data to it

    append from (file) delimited with blank

    .http://techrepublic.com.com/5208-6230-0.html?forum...

    • Commenter avatarLogin to reply the answers
Still have questions? Get your answers by asking now.