only the query.
But i think a good connection improve the good query.
I use the tipical ado jet ole 4.0 connection and VB6 classic. for example:
Set CONN = New ADODB.Connection
I need to loop line by line a txt file with approx 2.600.xxx lines!!!!
How to with a reasonable time for looping?
GAFSTRING = "C:\GAF_TENDER\VIAGGIANTI_TABELLE.MDB"
Set DATA_MART_CONN = New ADODB.Connection
I need suggestion to find value in recorset....
wath is the best:
- SQL1 = "SELECT filed FROM table WHERE filed='" & abc &...
sorry for up!
hi to the all!
first sorry for my terrible english...
Please tell me "10 gold rules" to speed up connection & recordset with ADO and Access mdb...
Separate names with a comma.