In excel you can use the command Networkdays to calculate the number of working days. This function is not available in ACCESS, does anybody know of another way.
I need to import data into table(s) everyday and if the record already exists require it to be updated with the new data. Each data file has approx 4,000 records and to make two passes at the file using Update and Append Query takes ages, does anybody know of an easier way.
When trying to telnet to nt server I get :
telnet: Unable to connect to remote host: Connection refused
Can anybody give me pointers to setting up access so that this can be done. ( it is to be used to transfer files )
Cheers
I am receiving data from an external source on a weekly basis, does anybody know how I can append the records so that current records are modified so show the new status.
Currently using the following to add records from my import file:
Open MyfileName For Append As MyFil
While Not EOF(MyFil)
Line Input #MyFil, MyLine
Select Case UCase(Left(MyLine, 2))
Case Is = "00" 'Header Line DONE x...
I receive a data file that includes HEADER/DATA/FOOTER etc.,
ie.
HEAD19072001BATCH4
01John Smith
0212 Street, Manchester
03100720011420Water Burst Paul Jackson
TRAILREC003
The first 2 characters of each DATA line are the type of data and as such require inserting into relevant file, ie...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.