> I am using VB6, AD0 V2.5 and SIBProvider (Have also tried IBPHOENIX
> free & trial). Using ADO Connection & command objects I have tried
> to perform insert statements on tables in my backend. I have tried
> it with a simple insert statement, a statment executing a stored
> procedure, and a command object executing a store procedure with
> named parameters. The last is by far the fastest, but gets 250-300
> transactions /s. I really need advice on what is the fastest way to
> use VB6 and an OLEDB Provider. Since i need to work with millions of
> records I need a way to move them into the backend in minutes, not
> hours, days & months. Any help is appreciated
>

I think the fastest way is to contruct and external file (text fixed field
length) file, then declare the structure to the db as an external file, then
issue an INSERT * into INTTABLE select * from EXTTABLE
Alan