Recent content by pamo

sorted the problem many thanks

I have two vbs files that run and transfer data into a database. I need to create a batch file in ms-dos which is set up in scheduled task to run every night at 1am. How?? I need to know what to write in the blue screen editor for the batch file

I am copying data from a access table into a sql table using a vbscript as shown below in BETWEEN THE *****. When executing the script the script performs some data format changes. as the date fields are split into a logon date + time and logoff date + time. The problem i have is that the time...

i am copying data from an access table into a sql table. i am using a vbscript to transfer the data across, here is a copy of the script i am using ************************************************************************************************************************ dim varLOOP dim Sqlstring...

will this work within my vbscript as i need this to happen for every record set inserted and bearing in mind i have 2 million records to pull across i dont want 2 have to do this 2million times!! so will i be able to put it into my script and allow it to loop like the script is already looping ???

I have a table which has imported data thru the use of a vbscript. I have a time field for logon_time and logoff_time. The problem is that a time for eg: 07:09:50 being 7am 9 min and 50 sec is being truncated to 7:9:50. so all leading zeros are removed. I HAVE BEEN TOLD THAT CStr function will...

ok but will i be able to put this into my vbscript so that it automatically does it for each and every record that is coming across as i have at least 2 million records which need the same formating done to it

I have a table which has imported data thru the use of a vbscript. I have a time field for logon_time and logoff_time. The problem is that a time for eg: 07:09:50 being 7am 9 min and 50 sec is being truncated to 7:9:50. so all leading zeros are removed. I HAVE BEEN TOLD THAT CStr function will...

Hi all. Am new to this site and to SQL so treat me with !!! I have imported data from a MS ACCESS file. Not all of the data from the MS access table has been transfered to my sql tables. Septemebers data does not appear at all and Nov and Dec's data only shows data from 1st - 9th december ...

I have been asked to create a XML specification and suprise suprise i dont know how to!!!!!!!!!!!!! Can anyone suggest any Templates, websites or advice on how i should do this and what needs to be included. I have searched on google looking for xml spec documents but cannot find anything...

no what i am doing is i have a access database which stores the data of the calls made to a switchboard. This then needs to be transferred to a SQL database which is where i am moving the data too. SO to answer ur question the databases do already exist thing is it runs fine and says succesfull...

HI BELOW IS A CODE I HAVE WRITTEN WHICH DOES NOT SEEM TO BE WORKING. I CANNOT IDENTIFY ANY PROBLEMS WITH IT, CAN U !!!! CHEERS FOR ANY 1 WHO CAN sorry i put in the whole code as i aint got a clue where the error is coz the thing is no error comes up when i run it but it doesnt update the...

HI BELOW IS A CODE I HAVE WRITTEN WHICH DOES NOT SEEM TO BE WORKING. I CANNOT IDENTIFY ANY PROBLEMS WITH IT, CAN U !!!! CHEERS FOR ANY 1 WHO CAN PAMO HERE IS THE CODE COPY AND PASTE IT INTO NOTEPAD OR SOMETHING: dim varLOOP dim Sqlstring dim SqlInsert dim Conn dim Rs dim ConnWrite dim objcmd...

I have some tables in Internet Explorer 5.5 . Which i want to copy and insert into a oracle table on a database server. From here i want to be able to access the table and perform checks on clients. Once i have done this i would like the information to be copied back to the web page and sent...

many thanks vb5prgmr, much appreciated