Recent content by talha

copying all data from these files into a single MS Access table

Hi, I have about 100 files (.html). Is there a way to automatically upload data from these files without manually opening and copying it into the MS access table? Thanks

This is great, it worked... I am so happy A big thank you

although off the topic, but it might be relevant, The other thing that I noticed is that when running test2() and test3() I got error message in test2() as potentially it hit more invalid URLs

Here is the file that I am using for reference

Nope

The code is working fine with just one last issue... If all the URLs are valid, then there is no error message and it works like it should be if any of the URL is not valid then the code works but throws following message at the end at this line

that fixed my first issue by I am still having challenges with this one 2. if the URL is invalid then it throws the run time error 5 If the URL is invalid, I still want the system to proceed

Thanks again for your assistance Here is what I did 1. Created a new Table (Name: URLT) 2. Saved a list of URLs to the table URLT, under the column URL_To_Call 3. Loop through the table to extract data... here is the code Private Sub test1() Dim strURL As String Dim db As Database...

And how to extract email address as well

Hi, thanks for the solution... it is about 90 percent of what I was looking for. Could you please guide on A) how to run this code for 100 URLs that I can save in a table B) Why is it saying email is protected, and how can I extract email addresses? Thanks again. I am super excited.

I am open to the options... it can be in a table, or we can hardcode it to VBA, etc.

Hi, Is there a way I can automatically extract contents from the URL and save them in the table? Here is a sample URL: jobs.nvoids.com/job_details.jsp?id=1246753 I want to extract data daily from about 100 URLs, and I don't want to do it one by one. Thanks

Hi, I have a customer table that has a column (Customer age). I also have a reference table that has an age range and based on where the customer age falls, it identifies an age_Group. I need to know how to do this through SQL. Here is what I am trying to do I tried following, but it...

Hi, I am using the following formula. Select a, b, c, d, (a+b)/c) as perc from table x group by a, b, c, d The above works when I have a value in both a and b, but if either field a or field b is null, then the formula returns nothing... I've attached the sample file Please advise how to...