Daily posts of Excel tips…and other stuff
Archive for the ‘External Data’ Category.
Hi everyone,
I have had a Dutch article on XML and Excel on my site for quite some time now, but never got round to translating the thing into English.
Well, yesterday I found a bit of time during a long train-ride, so here it is:
XML And Excel
From the intro:
Microsoft Office 2003 Professional was the first Office [...]
As I mentioned earlier, I want to develop a framework generating app to create some of the code necessary to read and write to and from an Access database. This is iteration 1 of about 100.
Start with this table in Access
Set a reference (Tools - References) to Microsoft ActiveX Data Objects 2.8 Library.
Then run [...]
Here’s some code I have to generate a SQL statement
Public Function BuildRepSQL(ByRef clsRepLine As CRepLine, eType As aiDBStatus) As String
Dim sReturn As String
With clsRepLine
Select Case eType
Case aidbstatusdelete
sReturn = "DELETE * FROM tblRepLine WHERE [...]
Elton is trying to create a QueryTable based on a named range in a closed Excel file. When the code tries to refresh the QueryTable object, he gets an SQL Syntax Error message. Although he’s sure his SQL syntax is correct, it’s almost certainly not. The syntax you get from the macro [...]
I answer about four questions a month on the newsgroups. I’m off to a roaring start in April, but I don’t like my answer much. I never know just how “correct” an answer to give. So I gave an answer that I felt was appropriate for the original poster and I’ll give [...]
Laura asks:
I am trying to use one query but with multiple paremeters depending on the cell. For example I have a list of dates in Column A and I want to run the query for each dates shown in column B, so the paramter for B1 is A1, B2 is A2 etc.. How do I [...]
On an ongoing project, the client uses the TM1 OLAP system. One of the interesting things I noticed was this:
A user can “slice” data from the database into Excel. The result is a new worksheet where the appropriate cell contains a formula such as =DBRW(…), which essentially looks up the TM1 database for [...]
I’m getting an error in MSQuery. I’ve had nothing but trouble with MSQuery since I changed employment. The current error I’m getting is:
The Microsoft Office Access database engine cannot find the input table or query ‘mdb.tblDocuments’. Make sure it exists and that its name is spelled correctly.
Aside: I just had to [...]
