Ich möchte gerne eine Access-Abfrage in Excel importieren per VBA.
Wäre froh um einen Code ansatz.
Besten Dank und Gruss
TOM
Sub import()
Dim db As Database
Dim rs As Recordset
Dim rng As Range
Dim abfrage As String
Dim colpointer As Integer, rpwpointer As Integer
'Datenbankconnect
'Hier haben .xls und .mdb Datei gleiche Pfadangabe:evt. anpassen
Set db = OpenDatabase(ThisWorkbook.Path & "\SDQArchiv.mdb")
'Abfrage
abfrage = "SELECT xyz,abc FROM Tabellexyz WHERE ..."
Set rs = db.OpenRecordset(abfarge, dbOpenSnapshot)
'Zielbereich
Set rng = Sheets("Deinsheet").[B2]
rs.MoveFirst
rowPointer = 0
Do While Not rs.EOF
For colpointer = o To rs.Fields.Count - 1
rng.Offset(rowPointer, colpointer) = rs.Fields(colpointer)
Next colpointer
rs.MoveNext
rowPointer = rowPointer + 1
Loop
rs.Close
db.Close
End Sub