Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Excel/VBA - using spool when accessing database
- I'm testing a simple VBA code which reads data from a remote mySQL DB and displays it in an Excel worksheet. Everything works fine until I print the sheet(Print/Print preview or Cute PDF).After printing, the DB access becomes painfully slow. The cure is to Exit and reopen the worksheet.I can...
- Tags: arild@..., Create, CREATE DIRECTORY, Create Directory Access, database, excel, Microsoft Excel, mySQL DB, NAME COLLISION Options, printing, spooling, VBA, windows
- Discussion threads 2005-11-23
- << Previous
- page 1 of 1
- Next >>
