Search results

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

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...

Hello, I have around 1000 values that I'd like to execute against my SQL code and store the resulting data in a table for further analysis. Here is an example of my SQL code: INSERT INTO Summary_Final ( PD_Deadline, stock, sell, [count] ) SELECT x.PD_Deadline, x.stock, x.sell, x.[count] FROM (...

Hi, I am new bee to Access and want to send emails to a multiple recipients through MS Access/Outlook. here are my requirements Recipient addresses are stored in a table (about 1000 of them) Message and subject will be the same for all the emails want to send one recipient per email want to...