By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,226 Members | 1,435 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,226 IT Pros & Developers. It's quick & easy.

Import file from a website into a table

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
8 Replies


P: n/a
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.

Nov 13 '05 #2

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

Nov 13 '05 #3

P: n/a
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!

Nov 13 '05 #4

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

Nov 24 '05 #5

P: n/a

<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
Nov 24 '05 #6

P: n/a
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.

Nov 24 '05 #7

P: n/a
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.


Nov 29 '05 #8

P: n/a
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?
Nov 29 '05 #9

This discussion thread is closed

Replies have been disabled for this discussion.