Search results

  1. I

    specific cells from Excel to Access

    Hey guys , i am trying to extract data from the specific excel cells to store into my access database. however, i have no idea how about i should be doing this .. any advice would be greatly appreciated !
  2. I

    exporting from access to specific cells in excel

    hey all, i need help where i export certain data(only data without the id) from access into specifc cells of excel. so for example : NseriesNo in Cell x NTradeDate in Cell Y NValueDate in Cell Z My codes are as followed: Dim rst As DAO.Recordset Dim ApXL As Object Dim xlWBk As Object Dim...
  3. I

    help with joining SQL statements

    hey guys, i am having problems in joining these 3 sql statements: Select NTradeDate, NValueDate, NMaturityDate, NTenor, NoteCurrency, NFaceValue, FCouponRate From tblStrucutredNotes where NseriesNo = SeriesNo Select SecurityCode, SecuirtyPrice FROM tblUnderlyingStocks WHERE SSeriesNo =...
  4. I

    Extract Specific Data from Access

    Hi guys, was wondering from Access , is it possible to just extract specific data only ? my codes are as followed: Dim rst As DAO.Recordset Dim ApXL As Object Dim xlWBk As Object Dim xlWSh As Object Dim fld As DAO.Field Dim strPath As String Const xlCenter As Long =...
  5. I

    Access to Excel (2003 version) VBA coding help

    Hi guys, I can’t seem to find any resources online regarding my problem. In fact, I don’t even know how to start! Basically: - An investor can choose to acquire a maximum of 8 stocks for his/her portfolio - So for example, investor1 just chooses stock1, stock2 & stock3 -...
Back
Top Bottom