DoCmd.TransferSpreadsheet, but in CSV there's an inherent bug so I created my own export module. Plus a special function that saves file to disk, which I modified a bit to make it work on 64 bit machine.
Showing posts with label VBA. Show all posts
Showing posts with label VBA. Show all posts
MS Access Export to Excel or CSV
Exporting data from Ms Access 2007 to Excel from code is just a one line statement using
MS Access VBA programming
MS ACCESS is a Rapid Application Development ms-office application, that is rarely used nowadays by programmers, obviously it's because it was designed for non-tech savy person to develop applications with no or minimal coding requirements.
MS-ACCESS, if to be taken seriously as one programming tool, it could not just develop simple applications, it could also handle enterprise level SQL as backend database.
MS-ACCESS, if to be taken seriously as one programming tool, it could not just develop simple applications, it could also handle enterprise level SQL as backend database.
Subscribe to:
Posts (Atom)