Microsoft.ACE.OLEDB.12.0 query problem

Strenkowski, Jack 1 Reputation point

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

    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 => Treating data as text => IMEX

  2. Abhi Kadam 26 Reputation points

    To resolve install

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

    Steps to install:
    1: Open CMD in administrator privilege

    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) us/download/details.aspx?id=13255

     Microsoft Access 2013 Runtime
    (Microsoft.ACE.OLEDB.15.0) us/download/details.aspx?id=39358

     Microsoft Access Database Engine 2016
    (Microsoft.ACE.OLEDB.16.0) us/download/details.aspx?id=54920

    0 comments No comments