Read a text file on C drive using Front Page

B

Burt Rosner

Hello Anyone,

I would like to read a text file from my C drive to a MS
Access (2002) table using a Web page.

Would asnyone know the command to do that???

Thanks, in advance for your help,

Burt
 
T

Thomas A. Rowe

For Security reasons and browser security settings, you will not be able to
allow a web page to interact with the desktop. Now it is possible to write
custom ASP code to allow the file to be uploading by a user to a specific
folder and then from a custom ASP application import the text file content
into the database.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
B

Burt Rosner

Tom,

Thanks for the info. What commands would I use in ASP to
get the ball rolling?

Thanks agiain,

Burt
 
T

Thomas A. Rowe

1. You need to use a file upload component, so you need to check and see
what is installed on your host or what they are willing to install, such as
ASPUpload.

2. I think you would then need to look at using FileSystemObject for opening
the text file, but as for how to actual read and then import, I am not sure
what else you are going to need, as this is something I have not had a need
to do.

I either manual inserting the data directly into the database on my desktop
or providing forms for data input, but I do use ASP to allow clients to
export the data to Excel or .csv formatted files.

I would suggest posting this to the ASP newsgroup

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
 
B

Burt Rosner

Thomas,

Thanks,

Burt
-----Original Message-----
1. You need to use a file upload component, so you need to check and see
what is installed on your host or what they are willing to install, such as
ASPUpload.

2. I think you would then need to look at using FileSystemObject for opening
the text file, but as for how to actual read and then import, I am not sure
what else you are going to need, as this is something I have not had a need
to do.

I either manual inserting the data directly into the database on my desktop
or providing forms for data input, but I do use ASP to allow clients to
export the data to Excel or .csv formatted files.

I would suggest posting this to the ASP newsgroup

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp




.
Click to expand...
 
Top