Search results for query: *

Howdy folks, New to SSIS. Here is the situation. Seems to be a very simple task but I need some guidance here. Both the source and destination are oracle tables. I have an oracle table. I need to read data from source oracle table (based on a "where" condition) and insert into another oracle...

How to get the text box sting value in an excel formula

I am launching a VB6.0 application from MS Access 2003 application using Call Shell("K:\newapp.exe") If I want to pass command-line parameter along with the application name. How can I do that? thanks nath

I am using Oracle 8i as back-end. Date and time is stored in a field . the content of the field is 3/10/2005 5:00:03 PM I am trying to write a query (in VB 6) where I want see if the today's date matches with the date (not the time) stored in that field. this is how I wrote and it doesn't work...

I am using VB6 with oracle 9i as back-end. I am using the following code to update record which has a 'Date' data type (oracle) field. The update happens correctly, but how can I store even the time in the same field? strSQL = "UPDATE xxx.AT_VRC_ADVANCES SET strSQL = strSQL & " ...

I am using transfertext method of the Docmd to basically read the contents of an ascii file whose name & path is g:\apsdata\junk\dna_120104.old. right when it hits the following line of code, DoCmd.TransferText acImportDelim, , "tblGr_CallableDNIndexStage", nfile I get the error "3027 Can't...