Jim Thomlinson wrote:
How could I create that Access db on the fly at runtime, use it to
load and
handle the data, then destroy it?

I tried using the Access 9 Library in VBA, and there is no 'dim oDB
as New
Database' option

Sub Test()
Dim Cat As Object

' Create Jet DB
Set Cat = CreateObject("ADOX.Catalog")
With Cat
.Create _
"Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=C:\New_Jet_DB.mdb"

' Use Jet DB
With .ActiveConnection
.Execute "CREATE TABLE Test(data_col VARCHAR(50) NOT NULL);"
End With

.ActiveConnection = Nothing
End With

' Destroy Jet DB
Kill "C:\New_Jet_DB.mdb"

End Sub

Jamie.

--