data query

Hello, I've recently started working with data queries and I've run into a little bit of a problem that I hoped to get some advice on. Context: I've got a "master" sheet where all the data I'm querying needs to be aggregated to. There are around 10 worksheets which I'm querying data from...

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

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

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

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

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

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

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

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