[AccessD] OT: Getting data from .txt into VB or web page

dim f as long
dim strTemp as long
f=freefile
Open "C:\MyFiles\ServerA.txt" for binary access read as f
strTemp=space(LOF(f))
get f,,strtemp
Close f
Debug.Print strTemp

-----Original Message-----
From: Roz Clarke [mailto:roz.clarke at donnslaw.co.uk]
Sent: Tuesday, February 04, 2003 5:20 AM
To: 'accessd at databaseadvisors.com'
Subject: [AccessD] OT: Getting data from .txt into VB or web page


Hello all
 
This isn't an Access question but I can't think of any better people to ask.
 
I've been tasked with writing a logon application for our Terminal Server
network that will take the user's username & password, and then query a text
file to find out which of the application servers is the least busy, before
connecting the user to that server.
 
The text file will be in the format
 
serverA,18
serverB,4
serverC,12
 
etc., where the number is the number of currently connected users.
 
I don't even know where to start. The notwork guy is keen for me to make it
browser based, but I don't see what advantages that would have over a little
VB app. Either way I don't know how to get the data out of that .txt file.
 
Is that enough info for anyone to help? Any pointers?
 
TIA
 
Roz

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030204/503bbaf5/attachment-0002.html>