Excel VBA - "[Microsoft][ODBC Text Driver] Record is too Large." - Joining 2 csv files.

Hi @CK76,

Thanks for your reply.

The issue is, if i replicate this scenario by importing the 2 files in `MSAccess` and run the same query, it seems to easily generate the crosstab. Why is it able to do so, as i am itself using a `Microsoft Access Text Driver`? Is there some `Extended Properties` for the Driver that i am missing, that may do the job?

BTW, these are small csv files. The maximum rows in the File2.csv is 60 rows and that too, i am only pulling only 2 columns from it viz., `geneid` and `TextValue` columns. So don't know why it shouldn't work.

If you mean Get & Transform i.e. Power query, i am aware of it. But cannot use Power Query transformations due to other reasons.

Can you please share an example on how to use the `Microsoft.Mashup.OleDb` Driver to run the SQL query? I have other sheets that have similar queries that also use the `Microsoft Access Text Driver` with other csv files. So if `Microsoft.Mashup.OleDb` works, then i will use it for generating other sheets data also.

Thanks.