Textfile Manipulation

[Lenny1]

Hi All,
Can someone give me an example if it is possible to connect using an asp page to a text file and parse data from the text file and insert it into an access database residing on the web server. The text file is also on the web server.

Thanks,
Lenny

[Newsgroup_User]

The last time I did this (and it was a *looong* time ago) I used
Data-binding, but it was IE only.

There might be updated procedures associated with that, or even an
extension.

HTH,

Jon

"Lenny@ford" <webforumsuser@macromedia.com> wrote in message
news:eo3mpe$q2f$1@forums.macromedia.com...
> Hi All,
> Can someone give me an example if it is possible to connect using an asp
> page
> to a text file and parse data from the text file and insert it into an
> access
> database residing on the web server. The text file is also on the web
> server.
>
> Thanks,
> Lenny
>

[Newsgroup_User]

Yes, although its been years since I`ve done it, as I use PHP now, so I
can't give precise details :-)

However, you read in the file using the FileSystemObject (do a search in
google for it for instructions on use), and then you can use string
manipulations to parse the file and break it up (if its a csv file, break it
first by new lines to get each record, and then by comma to get each field).
You can then insert the records into the database.

--
Gareth
http://www.phploginsuite.co.uk/
PHP Login Suite V2 - 34 Server Behaviors to build a complete Login system.