MS Access RRS feed

  • Question

  • User-1003884971 posted

    Hi Members,

    I need some help regarding data writing into an MS Access file.

    I'm working in VS 2003, C# and I need to write some data from sql to an MS Access file. The SQL query retrives some duplicate values from data base but I don't want these duplicate values to be written into MDB.

    How I can restrict duplicate values to be written into MDB.

    Here I'm using single object to insert into MDB.

    Kindly,  suggest in this regards.



    Saturday, June 21, 2008 2:02 PM


  • User537870505 posted

     How about selecting only unique rows using the DISTINCT keyword in the SELECT statement?

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Saturday, June 21, 2008 2:46 PM