Search results

  1. Y

    Select unique record

    Many thanks. Now I would like to fill an array with the country name, the codes are as following, but there is problem with "varArray(i) = rec("Country")" strSELECT = "SELECT DISTINCT Country" strFROM = " FROM tblIndex " strSQL = strSELECT & strFROM Set rec =...
  2. Y

    Select unique record

    Thanks in advance for your help. I have an Access database and the record is like this: Date Country Type Index 1.1 Canada A 2.1 Canada A 3.1 Canada A 4.1 Canada A 5.1 Canada A 6.1 Canada A 1.1 US A 2.1 US A 3.1 US...
  3. Y

    import date from Excel to Access?

    many thanks. My codes are as following: Sub UpdateIndexes() Dim rec As DAO.Recordset, inad1 As Address, i As Integer, Set db = CurrentDb Set rec = db.OpenRecordset("tblIndex") inad1.Wbook = "\\c\file\*.xls" Excel.Workbooks.Open inad1.Wbook, False, True...
  4. Y

    import date from Excel to Access?

    many thanks. My codes are as following: Sub UpdateIndexes() Dim rec As DAO.Recordset, inad1 As Address, i As Integer, Set db = CurrentDb Set rec = db.OpenRecordset("tblIndex") inad1.Wbook = "\\c\file\*.xls" Excel.Workbooks.Open inad1.Wbook, False, True...
  5. Y

    import date from Excel to Access?

    Many thanks. But I am afraid it is not that simple. I can not directly import the excel data, as I need to dispaly data with different forms in Access. I have almost done all the codes with VBA, the problem now is I want to creat a loop to refresh the data in Access from different sheets. I...
  6. Y

    import date from Excel to Access?

    Hi, I want to transfer an excel spreadsheet to Access, which contains several sheets. Could anyone tell me how to refer to each sheet when using VBA? Many thanks.
View older results
Back
Top Bottom