VB Forum / Database Access / February 2008

Developing a VB6, SP6 program using ADO to read a csv file into a recordset
using this code:
casInputFileConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & "Data
Source=" & casInputPathString & ";" & "Extended

I would like to automatically generate query commands with the
OleDbCommandBuilder. The Problem is, after creating an instance of a
CommandBuilder object, there is only  a SELECT Command - no INSERT, UPDATE
nor DELETE. The values are Nothing.

I am having a wealth of problems connection my sql express projects to
a remote SQL database through Visual Basic Epress 2008.  Connecting it
to a local store or an access database on a network drive works just
fine.  I can even connect to the SQL Express database using SQL

I'm just at the point of giving up on this aspect!!
I'm using Visual Studio 6 (so VB 6) to develop my app.
I have a good looking icon for my app, which is a white circle with bits
inside it, and with XP I get a good finish rather than the crappy Win98/Me

Developing a VB6, SP6 program using ADO.
If i cycle through a recordset and want to update a previous row with fields
from the current row, how would i do that?  I have the basic logic as you
can see below, i just don't know how to refer to a recordset row that has

I create ADO recordset and populate it with data from an external data
sourse (Intuit QuickBooks data file). There is no way to select only records
I need due to limitations of the approach I use (Intuit SDK). Then I loop
through all records and delete unwonted ones.