Using dbCopy instead of Import for speadsheets.

Kenneth Brody kenbrody at spamcop.net
Mon Mar 11 11:01:04 PDT 2013


On 3/11/2013 1:48 PM, Bob Simcoe wrote:
> Until recently, whenever I needed to import from an Excel spreadsheet (
> every month, 7,000+ lines, 10 fields, , and " ), it was very simple. Save
> the spreadsheet as a dbaseIV file and use fp's dbCopy. Then fix things up
> in Define Files and Screens. The reason I said  "until recently", was
> that new versions of Excel do not offer saving as a dbase.

OpenOffice.org can still read and write .dbf (as well as Excel) files, 
should the need arise.

On the other hand, doesn't Excel have the option to write tab-delimited text 
files?  (Use "f=\t" in filePro.)

-- 
Kenneth Brody


More information about the Filepro-list mailing list