Does Network Inventory Advisor export data into MDB (MS Access)?
Answer: Oh, sure. It definitely exports into MDB. Whenever you see the option to export into SQL, that’s actually what you need. As you know, SQL is the best option to store a database structure, as it is easily readable, occupies just a couple of kilobytes, and is easily transferable, that it why we did our best to make the SQL output as universal as possible. To import the exported SQL script into the new MS Access database, you’ll need to do the following:
- Export the report you need into SQL
- Get a copy of BatchAccess (a third-party utility, copyright belongs to its respective owner), install it and launch. You can Google for it, or request a copy from our technicians, it’s free, open-source, and quite useful if you deal with MS Access regularly
- Create an empty database in BatchAccess, and then Run the SQL script exported previously
- Ta-da! Your MDB database is ready to be opened in MS Access.