How can I to import data from Excel into a Paradox database using Delphi 7?
Import data from Excel
25.6k views Asked by user578332 At
4
There are 4 answers
0
On
This tool SMImport says it can do it. While they want $50 for it, you can download a free trial version.
1
On
Use the OLEDB Provider and ADO component in Delphi 7 to achieve this. It should be simple to do, and you can work with Excel querying via SQL queries.
Use the TADO component to get the data and then use BDE components like TQuery to import the data to the Paradox table.
Well, if you have the question tagged as Delphi 7 I assume you have BDE. This will enable you to do the whole process in Delphi.
You can modify and use this untested code (you will need to add the exception handling):