Microsoft.ACE.OLEDB.12.0 query problem

Strenkowski, Jack 1 Reputation point
2022-11-03T19:58:52.113+00:00

I'm having trouble with select * when a field has numeric decimal data like currency. these fields return null data.
i should also point out that when i look at the data in excel it has the warning that these cells have numbers stored as text.

Oddly if i create a mirror column and use a formula to add 0 or multiple by 1 to get a numeric stored then the select picks up the actual value.

Office Development
Office Development
Office: A suite of Microsoft productivity software that supports common business tasks, including word processing, email, presentations, and data management and analysis.Development: The process of researching, productizing, and refining new or existing technologies.
3,657 questions
Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,671 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 42,571 Reputation points
    2022-11-04T13:06:17.65+00:00

    That's really less on informations.
    How do you query data, which programming code and more, how does the connection string look like?

    One option is to use extended property IMEX=1 in connection to avoid, that ACE guesses in any way the data type of the column.
    See https://www.connectionstrings.com/ace-oledb-12-0/ => Treating data as text => IMEX


  2. Abhi Kadam 26 Reputation points
    2023-01-05T12:22:40.383+00:00

    To resolve install

    1: Microsoft Access Database Engine 2010 Redistributable
    Using below link.

    https://www.microsoft.com/en-in/download/details.aspx?id=13255

    Steps to install:
    1: Open CMD in administrator privilege
    276470-image.png

    2: Go the installable path of 32 bit Microsoft Access Database Engine 2010 Redistributable in CMD
    prompt and start the installation.
    Other OLEDB driver

     Microsoft Access Database Engine 2010
    (Microsoft.ACE.OLEDB.12.0) https://www.microsoft.com/en us/download/details.aspx?id=13255

     Microsoft Access 2013 Runtime
    (Microsoft.ACE.OLEDB.15.0) https://www.microsoft.com/en us/download/details.aspx?id=39358

     Microsoft Access Database Engine 2016
    (Microsoft.ACE.OLEDB.16.0) https://www.microsoft.com/en us/download/details.aspx?id=54920

    0 comments No comments