I'm trying to import data from several Excel files into one single workbook
but having a problem with blank cells. I now understand this is due to mixed
data types.

I 've updated my registry key to Zero "TypeGuessRows" What I don't
understand is the connection string which needs the following statement
adding "IMEX=1" please can someone give me an idots guide how I go about this!

Where / how do I add the statement, is it within Excel ?

Thanks in advance.