MS Access database was one of the standard data connections in DTS. Excel is listed as a scourc/destination, but access is not. Question:
What is the best connection to use for MS-Access databases for output of data
We generally process the ETL in SQL server then, export to Access database.
THANKS!!
Dave