Import file from a website into a table

[jtippen]

Can anyone point me in the right direction on how I can import a comma
delimited webpage off a website into a table in Access 2003?

If someone knows of an example of how to do this that would really be
great. My access knowledge is not too great unfortunately.

[pietlinden]

if you can save the thing as a text file, look up transferText in the
help. If you create an import spec, then it's a snap... you just
specify the filename.

[lylefair]

Contact the owner of the site and ask that person to send you a copy of
the file. Pay, if necessary.

[jtippen]

Well this is what i'm wanting to do:

I'm wanting to specify the url as a .php script file and manipulate the
url through variables in Access to generate the output that I need and
insert that data (which is comma delimited) into a table.

example:

http://www.website.com/filename.php?...var=MYOTHERVAR

gives me the output of:

data1, data2, data3, etc which I want to import into a table.

I hope I made that a bit more clear.
Do you think you can point me in the right direction on this one? :)
Thank you!

[jacoman1]

You assume that this person is out to steal something. Maybe you should
look into your own cynicism before going judgemental on others!

[Arno R]

<ja******@optonline.net> schreef in bericht news:11*********************@g49g2000cwa.googlegro ups.com...

You assume that this person is out to steal something. Maybe you should
look into your own cynicism before going judgemental on others!

Maybe it would be helpful if you would quote at least 'someting' of the thread that you are responding to ??
As I see it, (Google is my friend) the last answer on this thread was 3 weeks! ago !!

Arno R

[Lyle Fairfield]

I ran "SELECT SUM percent_cynicism FROM my_personality and it came back
100%.
As a side query I asked, why does someone want to mind data from a web
page? Do I have to do this for my own web pages? No, I don't because I
already have this data. Would, my daughter have to mine data from my
web page. No, she wouldn't; she would just ask me and I would send it
to her.
Who would have to mine it? My guess is someone that I didn't want to
give it to would have to mine it, unless they were just too lazy to
ask.
I suppose if I were tres stupide and the only way I could come up with
to get my own data would be by mining it, then it would not be theft;
it would just be stupidity.
So maybe it's not theft;maybe it's just that when your lover looks into
your eyes, he/she sees the back of your skull.
I hope that's not too judgemental for you. I've done my bery best to
put a positive interpretation on the OP's request.
Of course maybe he/she had permission to download the data as a comma
delimted text file and simple wanted to know how to load the data from
that file into a JET table. In that case, my cynicism about theft and
stupidity is misplaced and should be replaced with an admonition to try
asking the question you want answered instead of some other question.

[paul]

I've created Web sites that give the ability for a user to download a
CSV file. And a .csv file can be opened in Excel or imported into
Access via File | Get External Data...

Best regards,
J. Paul Schmidt, Freelance Web and Database Developer
http://www.Bullschmidt.com
Access Database Sample, Web Database Sample, ASP Design Tips

Can anyone point me in the right direction on how I >can import a comma
delimited webpage off a website into a table in >Access 2003?

If someone knows of an example of how to do this >that would really be
great. My access knowledge is not too great >unfortunately.

[rkc]

pa**@bullschmidt.com wrote:

I've created Web sites that give the ability for a user to download a
CSV file. And a .csv file can be opened in Excel or imported into
Access via File | Get External Data...

So what?