Search results

  1. H

    update query is not working

    update Query - UPDATE BNPARB_EOD_Sum LEFT JOIN Trades ON (sgn(BNPARB_EOD_Sum.Position)=sgn(Trades.TradePosition)) AND (BNPARB_EOD_Sum.ChildAccount=Trades.Account) AND (BNPARB_EOD_Sum.CTCLID=Trades.NNFComplianceId) AND (Cdate(BNPARB_EOD_Sum.[Trade Date])=Cdate(Trades.TradeDate)) AND...
  2. H

    can't read from temp table which was created from VBA backend

    i am createing Table directly from backed with help of text file (SELECT INTO command) (Create from back end) - following points 1.Command is - strSQL = "SELECT * INTO [Testing].[" & TblName & "] FROM [Text;HDR=NO;DATABASE=" & FileFullPath & "].[" & filename & "]" 2.Command for dumping data...
  3. H

    edit text file via link table showing error ISAM

    HI, Please help me how i can edit text file if i add as link table as i don't want to import and export text file. also have problem on link table to edit text file which is in comma (,) separated showing error " updating data in a linked table is not supported by the ISAM"
Back
Top Bottom