convert txt file into dbf file?
i want to convert txt file (text file) into dbf format. suggest any software.
- 1 decade agoFavorite 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.
- 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.
- essbebeLv 61 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
then append your data to it
append from (file) delimited with blank