Connecting to text files

[bj]

Has anyone connected to flat text files out there on a live site.

Im intrested to hear any feedback on performance. Is there a better format
(text tab delimited or csv, etc)

I have a offline system that replicates three times a day a 20,000, 5 column
text file to my web domain. It contains product info (Stock on hand, price,
etc.)

I want my web ap to access the file and provide info to customers. sure i
could probably schedule a stored procedure to insert the file contents into
a MS SQL table but the first option seems suffice if the perfomance is ok.

My site isnt "huge" so it shouldnt be a problem, should it?

[jdeline]

You can use an ODBC driver to connect to a CSV file.

[bj]

Hi jdeline

I realise i can connect via an odbc driver i was just wondering about
performance compared to a database table "in the real world". Im guessing
its not as quick as efficient as a database table.


"jdeline" <jdeline@deline.com> wrote in message
news:e3vdnm$2jp$1@forums.macromedia.com...

> You can use an ODBC driver to connect to a CSV file.