Accessing data in SQL Server via VBA

[yassem]

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:

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 : )

 

[ashuexcel]

Hi yassem,

First of all you have to add the reference of Microsoft Active X data objet in this project and then you can use this code given above.

in the provider you can use SQL server native client 10.0 or you can check from administrative tools in control panel.