| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update Excel Database via Access Main Database with a script | New Users to Excel | |||
| Connect to Access Database On Remote Server | Excel Discussion (Misc queries) | |||
| Manipulation of Data extract from Access Database | Excel Discussion (Misc queries) | |||
| Extract Data from an Access Database in to Excel | Excel Programming | |||
| How to access a database on a server from a local machine using od | Excel Discussion (Misc queries) | |||
![Clinton M James[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
