Search results

  1. G

    Excel code in VBA

    Bob, Thanks a lot for your reply. I am actually exporting data to excel from access and then comparing the difference between rows, if there exists any difference in cell values then i want to color those cells. For this i am using conditional formatting through VBA and i want to do this using...
  2. G

    Excel code in VBA

    Hi, I have written following VBA code in excel which i need to write in access. Sub Macro3() i = 2 Do While (Cells(i, 1) <> "") If (Cells(i, 1) = "CONU_TEMP.xls" And Cells(i + 1, 1) = "CONU_EIM.xls") Then Range("b" & i).Select Range(Selection, Selection.End(xlToRight)).Select...
  3. G

    Import data in text datatype

    Thanks a lot for your quick reply and i apologize for my late reply. I found the solution with your tips. Thanks again.
  4. G

    Import data in text datatype

    Hi, I have a csv file which i need to import into MS-Access as a table. I am doing this by using transfertext method. Now the problem is that i want all the data in CSV to be transfered as text data type in MS-Access table. I know we can create /update the specification file in import/export...
Back
Top Bottom