Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() NickHK wrote: Susan, <Duke's comment Pulling data from Access into Excel isn't difficult. Here's a starting point http://support.microsoft.com/kb/295646 It explains how to pull Access data into Excel using ADO. You don't need to do lots of coding if your queries are fairly standardized, and you may find it is much faster than having 60,000+ rows in Excel </Duke's comment NickHK Nick, seeing that I'm using Excel 2003, I went here http://support.microsoft.com/kb/246335/EN-US/ Followed it to the letter, clicked on the button, and got no responsen and Excel was non-responsive.. Question: I paste the code on the userform view code, after any existing code, which was 2 lines identifying the button? TIA for any leads. Susan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why are access query results different in Excel | Excel Discussion (Misc queries) | |||
Excel Data Query from Access | Excel Discussion (Misc queries) | |||
Access query results to Excel | Excel Discussion (Misc queries) | |||
Getting Access Query Data to Excel | Excel Programming | |||
Copy the results of an Access query into an Excel spreadsheet | Excel Programming |