||Re: Import/Export not all excel data can be imported
Akshat Kapoor <firstname.lastname@example.org>
||Wed, 15 Mar 2023 08:22:17 +0530
Good Morning James,
> 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.
I doubt you can open xslx files using dbase 5.
In current versions also you require a software like excel to open xlsx
oleautoclient is used to open/read data from the xlsx file using excel.