Connection string for all versions

[tiredofit]

With regard to ADO, to guarantee it to work for all versions of Excel, late binding is used.

However as for the following code, would it work for all versions of Excel? From my knowledge, there was something called Microsoft.Jet.

strcon = "Provider = Microsoft.ACE.OLEDB.12.0;" & _
             "Data Source=C:\MyData\;" & _
             "HDR=Yes;" & _
             "FMT=Delimited"""

So if the above does NOT work for all versions, what can be done?

Thanks

 

[Norie]

What are you connecting to?

 

[tiredofit]

What are you connecting to?

csv file