HELP: Need macro for excel to get data from server database and use results to populate an Access Da

  • Thread starter Clinton M James
  • Start date

Clinton M James

Hi all,

Is there a quick way to do a query on an SQL Server database and have the
output put direct into an Access Database?

I know how to do it by grabbing the records and then inserting each result
one by one, but this takes forever to complete and I am after a quick
solution, if it exists.

Is anybody able to assist ? is it possible?

Thanks in advance for any help!



you could link to the SQL Server table(s) from Access, write a SELECT query
to pull the records you want, and then turn the query into either an Append
query to add the data to a native table in the Access db, or into a
MakeTable query to create a new native table in the Access db, populated
with the queried records.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question