Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by naitx

  1. naitx

    Check Imported data from excel

    Hi, I have a query that will import excel file to access database,Is there a query that will check if the excel file was successfully imported?Or is there other way to do it...? Thanks in Advance!
  2. naitx

    datagrid column format

    Thank you SBerthold !!
  3. naitx

    datagrid column format

    Hi, How can I format Datagrid Column into percentage? Datagrid.Columns("fieldname").DataFormat = ??? Thanks in Advance
  4. naitx

    Create records based on the other table

    Thanks PHV!! Works like a charm!!
  5. naitx

    Create records based on the other table

    I have two Tables Split and GBS Split Country GBS Split PH aaa 0% PH bbb 10% US fff 4% US ttt 10% GBS Country Account GBS Split Total PH 1-abc comp...
  6. naitx

    delete duplicate based on two distinct fields

    thanks for replies....I got it working!
  7. naitx

    delete duplicate based on two distinct fields

    maybe I should post some real data from my database... ProductName ProductID ProductLevel Description ProdA 1-B68HT infant some description ProdA 1-B68HT adult some description ProdA 1-B68TF adult some description...
  8. naitx

    delete duplicate records based on two distinct fields

    I have a table called Products with fields ProductID,ProductName,ProductLevel,Description. ProductName ProductID ProductLevel Description ProdA A1 level1 blah... ProdA A1 level1 blah... ProdC A2...
  9. naitx

    delete duplicate based on two distinct fields

    Hi, I have a table called Products with fields ProductID,ProductName,ProductLevel,Description. ProductName ProductID ProductLevel Description ProdA A1 level1 blah... ProdA A1 level1 blah... ProdC A2...
  10. naitx

    Overwrite duplicate records from one table to another

    hi, I'm trying to Transfer all records from table A to table B and I would like to overwrite duplicate records from table B. this code only transfer the record but not overwrite duplicate records. cn.Execute "INSERT INTO B SELECT * FROM A'" can someone show me how to do this? Thanks in...
See more

Part and Inventory Search

Back
Top