import data from SQL 7 to Access with VB

[Karin]

Hi there

I am looking for the easiest way of importing data from Sql Server 7 to Access with VB, tried to work with the DTS package object and stumbled. Is there a query syntax that makes this job easy?

Thanx

Karin