Subject Re: Import/Export not all excel data can be imported
From Ken Mayer <>
Date Tue, 14 Mar 2023 21:32:43 -0700
Newsgroups dbase.getting-started

On 3/14/2023 4:12 PM, James Lavery wrote:
> Hello Dirk,
> Found enclosed below note (from Nov 2022) regarding Excel import/export.
> Info helpful to me: "append from array"
> My question: How do I identify to dBase5 that the Excel spreadsheet is an Array??
> The spreadsheet contains only letters and numbers.
> Developer Desktop does not recognize .xlsx files.
> What must I do to spredsheet/data for it to be recognized by dBase5 as an array.
> Help is greatly appreciated.

With dBASE 5 you are going to have to save the contents of the XLSX out
as CSV format (Comma Separated Values). This can be done with the File,
Save as option in Excel.

From there you will probably need to write some code to read the data
in as needed ... or, you could take a look at software from dBASE LLC,
such as DBFImport ... please visit the dBASE website for that.


*Ken Mayer*
Ken's dBASE Page:
The dUFLP:
dBASE Books:
dBASE Tutorial:
dBASE Web Tutorial:
dBASE DOS to Windows Tutorial: