View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Clinton M James[_2_] Clinton M James[_2_] is offline
external usenet poster
 
Posts: 16
Default HELP: VBA Code to extract data from an SQL Server database and put it into Access Database

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!

Regards
Clint