Search results

this time it states an error stating Run time error 13 , type mismatch

right i just tried using it but i have an error . my codes are as followed : Sub ExportExcelToAccess() Dim db As Database, rs As Recordset, r As Long Set db = OpenDatabase("Q:\Aaron\NotesDB-edit.mdb") Set rs = db.OpenRecordset(tblEDS, dbOpenTable) r = 210 ' where the row start Do While...

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 !

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...

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 =...

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 =...

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 -...