You're so correct Garner! After a lot of searching I found our reg-edit also. And while, in the time we needed it, we were working with Office 2003, here is what we did those days:
[HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Excel]
"AppendBlankRows"=dword:00000001
"DisabledExtensions"="!xls"
"FirstRowHasNames"=hex:01
"ImportMixedTypes"="Text"
"TypeGuessRows"=dword:00000032
"Win32"="C:\\Windows\\SysWOW64\\msexcl40.dll"
Looks pretty similar to the edit you just posted😃.
------------------------------
Rob van Rooyen
NEP GROUP INC.
Hilversum Netherlands
------------------------------
Original Message:
Sent: 06-25-2026 20:06
From: Garner Millward
Subject: Datalinq not importing all the data from excel file
I think the registry fix Rob is referring to is this one:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\16.0\Access Connectivity Engine\Engines\Excel
TypeGuessRows = 0
ImportMixedTypes = Text
Original Message:
Sent: 06-02-2026 06:23
From: Rob van Rooyen
Subject: Datalinq not importing all the data from excel file
I remember from a long time ago there was also an edit in the Windows Registry to fix this. Sadly I can't find this edit any more. Perhaps someone with a better archive can have a look?
------------------------------
Rob van Rooyen
NEP GROUP INC.
Hilversum Netherlands
------------------------------
Original Message:
Sent: 06-01-2026 12:09
From: Garner Millward
Subject: Datalinq not importing all the data from excel file
This is a decade old bug in the Microsoft ACE driver for data.
The max characters being sent from Excel is maxing out at 255 characters (exactly like in your image).
To increase the maximum you need to put more than 255 characters in the first row of the column you are getting data from. Then all the following rows will have their max character count increased.
It sounds silly but that's what it is.
-------------------------------------------