data query

  1. C

    Scraping Data from Webpage document into Excel

    Hello Excel Professionals and everyone who volunteer their support. I am having a problem. I am not sure if "Mr. Worf" or anyone out there can help me… I am asking for your time and patience and your knowledge, as this may sound complicated to understand… I have 18 weblinks which are...
  2. K

    Variable Time/Datestamp in Data Query

    Hello all, this is my first post here. I have tried finding an answer to my particular problem and haven't been able to. This is a snippet of the data query I am trying to write: SELECT Source.Item1 Source.Submitted_date Source.From_ID FROM Database.Source WHERE...
  3. bricol13

    Convert Text Data Queries to use Excel file as source file

    I have various workbooks that I've used for years to import data from .csv (text) files that were downloaded from my company system. These were run using buttons and Querytable Refresh macros, and worked beautifully, omitting unwanted data, maintaining my formats and updating/inserting...
  4. C

    Add named range from individual files to Folder source in Power Query

    I have a folder of files that I am querying for the files' date modified, file size, and a few other attributes. Long-story-short we have multiple versions of these files in subfolders and each "release" we make a new folder and copy the Excel files into them. So I created this query that can...
  5. K

    Web query for a password-protected web page

    Hello, I have a web page I would like to get data from, however when I started Excel my data was gone because I had restarted Excel and the data is password protected. All the other macros I found only open Internet Explorer and go to the webpage, but I need Excel's web query to automatically...
  6. M

    Large Access Query - How to Reference?? Help Needed!

    Hi all, I have a large Access database that will max out the number of rows Excel can handle. I am referencing part numbers that contain over 2 million items. My users only have Excel experience so I have been tasked with attempting to maintain that standard. Is there a way in Excel to pull...
  7. K

    Excel Data Query from SQL

    I am trying to generate several spreadsheets, sourcing the data from an SQL database. I am new to SQL. The only tool I have for accessing the database is MS Query. I have managed a lot by the copy & modify process, but now am stuck. I have the following code which allows me to select...
  8. E

    Data query from web fails to import most hyperlinks

    I'm new to Mr. Excel, but it looks like a great forum. Thanks in advance for your help. Using Excel 2007, I've set up a data query pointing at the following Japanese newspaper website: http://www.asahi.com/international/list2.html I selected full HTML formatting in the Web Query Options so...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top