ACT!6 - Can you export the .dbf files to a .csv file, or some sort of flat file, and if so, how?

Without any outside tools.
c9k9hAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rae_raeCommented:
Yes, you can use xls2csv to do this as far as I know. If you are using Linux, you can use the program I wrote to install this package. Simply copy this code into a text file and name it install.sh. Then from the Terminal, type sh install.sh to launch it. After you are done, type xls2csv to get the syntax for doing what you need. If you are in Windows, you can use this 30 day trial program: http://www.download.com/DBF-to-CSV/3000-2065_4-10405766.html
#!/bin/bash
 
clear
echo 'Launching installer for xls2csv installation...\n'
 
# Download and extract Unicode::Map
echo 'Downloading Unicode::Map...'
wget -q http://search.cpan.org/CPAN/authors/id/M/MS/MSCHWARTZ/Unicode-Map-0.112.tar.gz
if [ -f ./Unicode-Map-0.112.tar.gz ]
then
	tar -xf ./Unicode-Map-0.112.tar.gz >/dev/null
else
	echo 'Cannot download Unicode::Map from cpan.org so quitting...'
	exit
fi;
 
# Download and extract Spreadsheet-ParseExcel
echo 'Downloading Spreadsheet-ParseExcel...'
wget -q http://search.cpan.org/CPAN/authors/id/S/SZ/SZABGAB/Spreadsheet-ParseExcel-0.32.tar.gz
if [ -f ./Spreadsheet-ParseExcel-0.32.tar.gz ]
then
	tar -xf ./Spreadsheet-ParseExcel-0.32.tar.gz >/dev/null
else
	echo 'Cannot download Spreadsheet-ParseExcel from cpan.org so quitting...'
	exit
fi;
 
# Download and extract libintl-perl
echo 'Downloading libintl-perl...'
wget -q http://search.cpan.org/CPAN/authors/id/G/GU/GUIDO/libintl-perl-1.16.tar.gz
if [ -f ./libintl-perl-1.16.tar.gz ]
then
	tar -xf ./libintl-perl-1.16.tar.gz >/dev/null
else
	echo 'Cannot download libintl-perl from cpan.org so quitting...'
	exit
fi;
 
# Download and extract Text::CSV_XS
echo 'Downloading Text::CSV_XS...'
wget -q http://search.cpan.org/CPAN/authors/id/H/HM/HMBRAND/Text-CSV_XS-0.52.tgz
if [ -f ./Text-CSV_XS-0.52.tgz ]
then
	tar -xf ./Text-CSV_XS-0.52.tgz >/dev/null
else
	echo 'Cannot download Text::CSV_XS from cpan.org so quitting...'
	exit
fi;
 
# Download and extract OLE::Storage Lite
echo 'Downloading OLE::Storage Lite...'
wget -q http://search.cpan.org/CPAN/authors/id/J/JM/JMCNAMARA/OLE-Storage_Lite-0.17.tar.gz
if [ -f ./OLE-Storage_Lite-0.17.tar.gz ]
then
	tar -xf ./OLE-Storage_Lite-0.17.tar.gz >/dev/null
else
	echo 'Cannot download OLE::Storage Lite from cpan.org so quitting...'
	exit
fi;
 
# Download and extract IO::Scalar
echo 'Downloading IO::Scalar...'
wget -q http://search.cpan.org/CPAN/authors/id/D/DS/DSKOLL/IO-stringy-2.110.tar.gz
if [ -f ./IO-stringy-2.110.tar.gz ]
then
	tar -xf ./IO-stringy-2.110.tar.gz >/dev/null
else
	echo 'Cannot download IO::Scalar from cpan.org so quitting...'
	exit
fi;
 
# Download and extract xls2csv
echo 'Downloading xls2csv...'
wget -q http://search.cpan.org/CPAN/authors/id/K/KE/KEN/xls2csv-1.06.tar.gz
if [ -f ./xls2csv-1.06.tar.gz ]
then
	tar -xf ./xls2csv-1.06.tar.gz >/dev/null
else
	echo 'Cannot download xls2csv from cpan.org so quitting...'
	exit
fi;
 
echo 'Installing xls2csv and dependencies...'
echo 'Ignore any warnings about building XS version of libintl-perl'
 
# Make and isntall the Unicode::Map modules
cd ./Unicode-Map-0.112
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the Spreadsheet-ParseExcel modules
cd ../Spreadsheet-ParseExcel-0.32
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the perl modules
cd ../libintl-perl-1.16
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the text-csv modules
cd ../Text-CSV_XS-0.52
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the OLE::Storage Lite modules
cd ../OLE-Storage_Lite-0.17
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the IO::Scalar modules
cd ../IO-stringy-2.110
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Make and install the xls2csv modules
cd ../xls2csv-1.06
perl Makefile.PL >/dev/null
make >/dev/null
sudo make install >/dev/null
 
# Do a garbage cleanup
cd ..
rm -rf ./Spreadsheet-ParseExcel* >/dev/null
rm -rf ./Unicode-Map* >/dev/null
rm -rf ./libintl-perl* >/dev/null
rm -rf ./Text-CSV_XS* >/dev/null
rm -rf ./OLE-Storage_Lite-0.17* >/dev/null
rm -rf ./IO-stringy-2.110* >/dev/null
rm -rf ./xls2csv* >/dev/null
 
echo '\nFinished installing xls2csv. You may now run xls2csv using /usr/bin/xls2csv'

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
c9k9hAuthor Commented:
Thank you for your quick response!  I am using windows.  (Sure wish I could use your code!)  I'll check out the free trial.  Is reasonably priced.  Thanks again!
rae_raeCommented:
:) Glad to help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ACT

From novice to tech pro — start learning today.