Connecting Access Database to website to import data automatically

[alfredo245]

Hi experts,

I just created a database and need help connecting it to the data source. The data comes from a http website (intranet from work). When I open the link using firefox, I can view the website with the data in it, but when I open it from Internet Explorer, I get a save as pop-up message to save a csv file which contains all the data. The extension of the http website ends with csv. So it is something like http (slash slash...) [FONT=&quot]Intranetname/referral[/FONT][FONT=&quot]_dbase.csv[/FONT]

Currently, I am opening the file using firefox, copying all the data manually, and pasting it in a text file using notepad. After that, I import the file into access. The delimiter of the data is this symbol: |

I am trying to find a way to link my database to the website where the data is located so that I can skip the manual process of opening the website and copying the data and saving it into a text file and then importing that file into access. I was thinking to have like a form in access with a bottom that will automatically import that data from this link and paste it into a table in access using the delimiter symbol mentioned above.

Is this too complicated? Is it even possible in access 2010?



Thanks a lot!

 

[spikepl]

I think there is a post here somewhere about picking up a text file from a web site.

I think it contains the word FTP (even though the solution just used some msxml call or other). Do a thorough search of this site using google.