February 24, 2021, 03:11:32 PM

Author Topic: Export to MS Access Tables  (Read 4642 times)

clefler

  • Member
  • *
  • Posts: 2
Export to MS Access Tables
« on: September 15, 2004, 12: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!

Komodo Support

  • Administrator
  • Member
  • *****
  • Posts: 2699
  • Dayton, Ohio, USA
    • Komodo Laboratories LLC
Export to MS Access Tables
« Reply #1 on: September 15, 2004, 07: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.

clefler

  • Member
  • *
  • Posts: 2
Export to MS Access Tables
« Reply #2 on: September 15, 2004, 09:13:29 PM »
Thank you!

andrake

  • Member
  • *
  • Posts: 3
Export to MS Access Tables
« Reply #3 on: December 01, 2004, 10:24:25 AM »
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.