||Re: Importing Excel files
Mervyn Bick <firstname.lastname@example.org>
||Tue, 7 Apr 2020 17:48:31 +0200
On 07/04/2020 16:30, Geoffrey wrote:
> Hi All,
> I'm new/old to dBase. Used dBase II back in the 80s and developed a whole suite of admin software for small businesses. But that was then and this is now.
> Am trialing dBase 2019 with a view to building some software to replace an overburdened Excel system I have.
> But problem #1 I've encountered is how to import Excel files into dBase equivalents.
> I can create equivalent Tables, but have so far not managed to discover how to import data either directly from Excel files or by way of .CSV files.
> Can anyone out there give me some advice, please?
> And another thing ... there was a free utility available way back then called DBU.exe - is that still around? Or does anyone have something similar they'd be prepared to share (or receive a small payment for)?
The first thing to do is to fetch and install a copy of the dUFLP (dBASE
Users Function Library Project) from Ken Mayer's site at
http://www.goldenstag.net/dbase/ Instructions for installing the dUFLP
are on the site.
ImportData.wfm in the dUFLP should import .csv files from Excel for you.
An alternative is to use an oleAutoclient object to fetch (or place)
data directly from an excel file. This is more suited to regular, say
daily, imports but it is quite a bit more complicated. ImportData.wfm
will certainly get you started and you can move on from there.
If you enter Excel in the search field in this news group you will find
plenty of messages to get you going.
If you do decide to stay with dBASE 2019 Ken has written some books
(also available on his website) which are a really worthwhile
investment. You should also complete the Tutorial available on the
website to get a grounding in event driven programming. There is a
separate newsgroup for assistance with the tutorial.