Import from SQL Server...

[vbMark]

Hello,

I want to import some data from a SQL Server 2005 table into an Access 2007
table. I am able to import the entire table no problem, but this is not
what I want.

What I want is the ability to import data based on a query, but I can not
figure out how to do this.

Can someone provide a quick explanation, or provide a link to a solution?

Thank you very much in advance!

Mark

 

[S.Clark]

I think you can import from a view. If not, you can link to a view, then use
that as a basis for an append query. There are plenty of options, just not
the ability to import from an Access query of the SQL Server table.

Maybe explain your setup more. ADP, MDB, or ACCDB? Links, etc.

 

[vbMark]

Ok, I will just use views if that is the only way.

Thank you for your response.

I think you can import from a view. If not, you can link to a view,
then use that as a basis for an append query. There are plenty of
options, just not the ability to import from an Access query of the
SQL Server table.

Maybe explain your setup more. ADP, MDB, or ACCDB? Links, etc.

 

[Stefan Hoffmann]

hi Mark,

What I want is the ability to import data based on a query, but I can not
figure out how to do this.

You may use a linked table. Thus you can use Access/jet queries, but
depending on your table size this may be slower than a using a linked view.


mfG
--> stefan <--