MS Access database connection without connectivity toolkit

[beta66]

Hi guys

I'm developing an application that courrently reads data from a *.txt file. I would let the application read data from a MS Access database.

Is it possible to connect to MS Acces db and retrieve data without the database connectivity toolkit?

The result of second field (column) should be: current record - previous record. How can i do it, even reading data from *.txt data? 

Thanks for your help

beta66

[Dennis_Knutson]

If you don't want to buy the database connectivity toolkit, then you can give LabSQL a try. As far as using a text file, you should read the file into an array (i.e. with Read From Spreadsheet) and then the calculation of the second column is array manipulation. With text files, you have to read in the entire file and write it all out at once in order to add a column.

[beta66]

Hi dennis

thanks for suggesting me labsql, i dowloaded it.

I would really appreciate an exemple on how to calculate (using a *.txt file) "current record - previous record" and put the result in a second column.

Thanks

Ciao

Beta66

[Dennis_Knutson]

I left out the file read part. The easiest is to use Read From Spreadsheet to get a 1D numeric array from the column. I also don't know what you want done with the first result since there is no previous value to subtract. With a numeric array, some value has to be there. If you convert it to a string array, you can change the first value in the second column to an empty string before writing it.

[beta66]

Hi dennis

it's exactly what i was looking for!

Thanks a lot

I will take advantage of your patience and competence to submit you another question. I need to tranfer data from a Pervasive database into an Access database. Do you have an idea on how to do it ?

Thanks again

Beta66

[Dennis_Knutson]

Sorry, I'm not familiar with Pervasive. Can you create a link to it in Access? If Pervasive has an odbc driver, you should be able to do that and then do an import or query from Access. I'm far from being a database expert but I had to do something like this in the past with a SQL Server database and Access.