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