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
C

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!

Regards
Clint
 
T

tina

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.

hth
 

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

Similar Threads

HELP: VBA Code to extract data from an SQL Server database and put it into Access Database 1
Extracting audio from an Access Database 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
convert database to SQL server 2
Get results from Access Database. 1
Access Newbie trying to create Access Database for survey data 0
Do you need Access to use an Access Database for data entry only? 5
shared database/developer extensions/access 2003 1

Top