In the absence of other replies :-
1. I have not used the ADODB method, so cannot respond to this, except a simple web search shows you need to include something like :-
2. I have always used ODBC. I suggest you record a macro using Data/Get External Data from Excel to get code. Check via Control Panel 'ODBC Data Sources' that you have the Paradox driver installed (a standard content of the MS Office setup disk).
This should enable you to read data. I have no experience of your more interactive requirements eg. writing data.