MS Access and Internet - How to get *.txt file from a Website

Author

How to get *.txt file from a Website

DeWayne

2005-12-02, 9:24 am

Help!,

I need to get a copy of a *.txt file from a website. I've tried several
things in VBA but can't quite get there. I can get an activeconnection and I
can hypelink, but what do I do then?
--
DeWayne

end

2005-12-03, 7:23 am

DeWayne escreveu na mensagem
<9D8DBC66-8903-459F-AF06- D936F1DCA42A@microso
ft.com>...
>Help!,
>
>I need to get a copy of a *.txt file from a website. I've tried several
>things in VBA but can't quite get there. I can get an activeconnection and
I
>can hypelink, but what do I do then?
>--
>DeWayne

DeWayne

2005-12-06, 9:25 am

I don't understand the answer, pleas try again.
Thanks
--
DeWayne

"end" wrote:

>
> DeWayne escreveu na mensagem
> <9D8DBC66-8903-459F-AF06- D936F1DCA42A@microso
ft.com>...
> I
>
>
>

Amy Blankenship

2005-12-09, 9:24 am

Before I try to answer your question, I need you to confirm that you are
asking what I think you are asking...

1) you have a mdb file on a local computer
2) you are trying to read in a txt file from a web server that you do not
have physical (mapped or unc access to)
3) you do or do not have a url for the txt file...?

In other words, are you trying to FIND a file and don't know where it is, or
are you trying to READ a file and do know where it is?

-Amy

"DeWayne" <DeWayne@discussions.microsoft.com> wrote in message
news:9D8DBC66-8903-459F-AF06- D936F1DCA42A@microso
ft.com...
> Help!,
>
> I need to get a copy of a *.txt file from a website. I've tried several
> things in VBA but can't quite get there. I can get an activeconnection
> and I
> can hypelink, but what do I do then?
> --
> DeWayne

DeWayne

2005-12-09, 9:24 am

1). I have a mdb file.
2). I'm accessing an external website (WWW.CENSUS.GOV).
3). I have the URL.
4). I can access the *.TXT file through IE and do a "save as" to my computer.
5). I can do a sucessful ADO Connect. I can't get anything to work from there.
6). I cannot manually import the file to Access.
7). I cannot TransferText to Access.
8). The message I receive that makes the most since is
"'http://www.census.gov/const/C40/Table3/' is not a valid account name".
9). The file I'm attempting to get is
http://www.census.gov/const/C40/Table3/tb3u200510.txt.

Thank You for Your Interest in my Problem,
DeWayne
--
DeWayne

"Amy Blankenship" wrote:

> Before I try to answer your question, I need you to confirm that you are
> asking what I think you are asking...
>
> 1) you have a mdb file on a local computer
> 2) you are trying to read in a txt file from a web server that you do not
> have physical (mapped or unc access to)
> 3) you do or do not have a url for the txt file...?
>
> In other words, are you trying to FIND a file and don't know where it is, or
> are you trying to READ a file and do know where it is?
>
> -Amy
>
> "DeWayne" <DeWayne@discussions.microsoft.com> wrote in message
> news:9D8DBC66-8903-459F-AF06- D936F1DCA42A@microso
ft.com...
>
>
>

Amy Blankenship

2005-12-09, 11:24 am

You may be able to implement a technique similar to this
http://www.databasejournal.com/feat...le.php/3491216, where
you hit the page and retrieve the contents, rather than just hitting the
page. However, the specifics of retrieving the page require a good deal of
research that I don't have time to do for you.

HTH;

Amy

"DeWayne" <DeWayne@discussions.microsoft.com> wrote in message
news:C01368F6-DFB8-4FC0-919B- 55F386073154@microso
ft.com...[color=darkred]
> 1). I have a mdb file.
> 2). I'm accessing an external website (WWW.CENSUS.GOV).
> 3). I have the URL.
> 4). I can access the *.TXT file through IE and do a "save as" to my
> computer.
> 5). I can do a sucessful ADO Connect. I can't get anything to work from
> there.
> 6). I cannot manually import the file to Access.
> 7). I cannot TransferText to Access.
> 8). The message I receive that makes the most since is
> "'http://www.census.gov/const/C40/Table3/' is not a valid account name".
> 9). The file I'm attempting to get is
> http://www.census.gov/const/C40/Table3/tb3u200510.txt.
>
> Thank You for Your Interest in my Problem,
> DeWayne
> --
> DeWayne
>
>
> "Amy Blankenship" wrote:
>

Sponsored Links