Data Import Issue: Discrepancy between SQLite and Excel Values

[FahadYEC]

Hi Guys,

I'm currently facing an issue with importing data from SQLite to Excel using Power Query with the assistance of the ODBC Driver for SQLite3. The challenge lies in the fact that values in SQLite are enclosed within "{" and "}" brackets, but in Excel, the imported values appear entirely different and start with an "X."

Has anyone encountered a similar problem or can provide insights on how to resolve this discrepancy? I appreciate any assistance or guidance you can offer in troubleshooting and ensuring the accurate transfer of data between SQLite and Excel.

Thank you in advance!

PS: Here is the comparison

[FahadYEC]

The column type is "GUID"

[lbendlin]

Then I would call Excel's choice accurate, as GUIDs are in fact HEX strings.

[lbendlin]

That's cute. Excel decided to treat your strings as bytes in HEX notation (hence the X).  

One of the problems is that { }  has a meaning in Power Query  (positional indicator) which may throw Excel off a bit.

What is the column type for that column in SQLite ?