Komodo Labs Forums

NEWT Professional => NEWT Pro Network Inventory - Support => Topic started by: clefler on September 15, 2004, 03:54:00 PM

Title: Export to MS Access Tables
Post by: clefler on September 15, 2004, 03:54:00 PM
Hi there, has anybody exported the Newt tabs to .CSV files and then imported into MS Access for report generation purposes?  

The only way I know to do this is to create a table in Access for each .CSV file and import data.  Only problem is when I go to make a query for a report that involves the multiple tables, some of the Newt tables only have one record per machine (IE network, system) and some have multiple records per machine (IE software, local drives.)  So the records returned by the query have odd results.  

I know that's probably more of an MS Access question, but I was hoping someone had done this before with Newt.

Thanks for any info!
Title: Export to MS Access Tables
Post by: Komodo Support on September 15, 2004, 10:40:00 PM
We've been fully aware how difficult this would be to do, so NEWT Pro 2.0 will include the ability to export everything as a fully relational MS Access database and will include sample reports.
Title: Export to MS Access Tables
Post by: clefler on September 16, 2004, 12:13:29 AM
Thank you!
Title: Export to MS Access Tables
Post by: andrake on December 01, 2004, 01:24:25 PM
You are actually asking a MS Access question.  You will want to create a 1 to many relationship based off of the machine name.  Create a form/report based off the primary tab.  Then create a form/report based off the software tab.  Then put the software form/report as a sub form/report in the primary form/report.  It will ask you about how the relationship should be created.  It should show you the machine name field.  Select it and you now have what you are looking for.  You can do that for all the other pages as well.