Share via

Data Import Issue: Discrepancy between SQLite and Excel Values

Anonymous
2024-01-25T11:00:42+00:00

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

Microsoft 365 and Office | Excel | For business | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-01-25T13:41:22+00:00

    The string of characters you provided, {1bc8e695-b9F3-47BD-BFFF-382EF635B7F6}, is a GUID (Globally Unique Identifier) in its standard format. When you use Power Query to connect to a SQLite database, it may convert the GUID to a different format, such as X'95E6C81BF3B98D47BEFFF382EF635B7F6'. This is because different systems may use different formats for representing GUIDs. However, the underlying value of the GUID remains the same, regardless of the format used to represent it.

    Was this answer helpful?

    0 comments