I am currently writing aset of macros thatare supposed to get data from an SQL server, paste it in two sheets and then mash it up and send. Point 2. and 3. is easy but I have no experience with SQL whatsoever, hence thequestion.
I've read several other threads on the subject on this forum and elsewhere, but none of them have given my a desicive sollution.
From what I understand to connect I'd need Provider, Catalog, Data source as well as UserID and Passwor, let's say I now all of these : )
My SQL is as follows:
and simillar for the other table, how am I supposed to write it?
I would greatly appreciate a swift anwser and thanks in advance : )
I've read several other threads on the subject on this forum and elsewhere, but none of them have given my a desicive sollution.
From what I understand to connect I'd need Provider, Catalog, Data source as well as UserID and Passwor, let's say I now all of these : )
My SQL is as follows:
Code:
SELECT t.ni
a.namei
a.surrnamei
b.cityi
b.streeti
c.numberi
c.date
FROM bwe.ki
where date=
and simillar for the other table, how am I supposed to write it?
I would greatly appreciate a swift anwser and thanks in advance : )