Solved: Import Excel with own code.

[hansup]

In VBA we need only the = sign to assign a value to a simple variable.
[vba]strFoo = "bar"[/vba] But assigning to an object variable also requires the Set keyword:
[vba]Set myDataBase = CurrentDb.OpenRecordset(sqlQuery2)[/vba]

[Frenchy646]

But assigning to an object variable also requires the Set keyword:

VBA:
Set myDataBase = CurrentDb.OpenRecordset(sqlQuery2)

VBA tags courtesy of www.thecodenet.com

Ah, right, that's fair enough then.
Does VBA also have object variables for the simple variables, for complex operations ?
(for example, like the java Integer object which you have to use for methods like ParseInt() )

[hansup]

Does VBA also have object variables for the simple variables, for complex operations ?
(for example, like the java Integer object which you have to use for methods like ParseInt() )

I will guess the answer is no. But I should defer to some who knows Java.