I have not been able to get the ADS (Access Data Sync tool) to work properly for me. So I am trying to develop a work around.

I am using SqlCe on my handheld, no problems there. The problem is getting the needed data into SqlCe.

I can Import/Export the data to a delimited text file from my desktop app. I can also transfer these text files to the handheld and open them.

I can't use a "SELECT * FROM Data.csv" to load the data in a DataTable because it would require OLEDB and if I had that I would not need load Access Sync tool.

But CF20 does support Imports System.IO namespace and the StreamReader/StreamWriter Classes among some others.

So I could in theory use the StreamReader to read in line by line, loading each field into a DataTable, then save it using SqlCe on my handheld app.

Then I could export the modified data using StreamWriter to export back to desktop file....

All the needed tools are supported directly in CF20 and would no longer need Access or the sync tool.

If so, what are the limits in how many lines CF20 will parse... RAM available of course.

Is this a do-able workaround?
.