Hi Jason,
Thank you very much . That is a very good solution. I will try it .

Regards,
Fred

>Yes, you can use ADO and create a local temporry recordset in memory and treat it exactly like a database recordset. These are called "dynamic recordsets". Basically create a recordset, append new fields to the recordset and then off you go. Insert your records and you have a dynamic recordset. Hopefully the example code gives you the gist of it.
>
>Code:
>
>Dim rsFileInfo as ADODB.Recordset
>
>Sub cmdLoadData_Click()
>
>Set rsFileInfo = New ADODB.Recordset
>
>rsFileInfo.Fields.Append "ID", adInteger
>rsFileInfo.Fields.Append "FileName, adBSTR, 255
>
>rsFileInfo.Open
>
>rsFileInfo.AddNew
>rsFileInfo!ID = 1
>rsFileInfo!FileName = "tempfile.dat"
>rsFileInfo.Update
>
>End Sub