Importing Mas90 data help needed...

[tonyscsu]

I'm trying to create a macro or module that will automatically import data from a specific table in a mas90 database. Can somebody please help me with this....

 

[mcarbone]

I just finished converting a MAS90 system to SQL. Migration took 6 months.

Locate where the MAS90 tables are.

Then just create a DNS connection to the table in MAS90 you are trying to read. If you do that, you never have to update anything. You'll be hooked up live to the data.

Mark

 

[jfischer]

MAS90 sets up an ODBC data source named SOTAMAS90 that you can use to link to the MAS90 tables. You will be prompted by the data source for a particular MAS90 company code and user code. If you want to, you can make your own ODBC data source that automatically logs on to a specific company and user.

 

[tonyscsu]

How do you create an ODBC data source that automatically logs on to a specific company and user? As you can see I'm a novice..

 

[jfischer]

To add a MAS 90 ODBC data source:

1. Open the Windows Control Panel and find/run the ODBC Data Sources shortcut.
2. Choose the System DSN tab and click the Add button.
3. Select the MAS 90 32-bit ODBC Driver.
4. Enter something meaningful for your installation at the following prompts (example text is provided):

  Data Source Name:   MAS90_ABC
  Description:        MAS 90 ABC Sample Company
  Database Directory: F:\MAS90
  
  Company Code:    ABC
  Default User ID: DEMO
  Password:

  Cache Size MB:   4
  Dirty Read:      (Check this)
  Burst Mode:      (Check this)

Then, open your MS Access database, click File, Get External Data, Link Tables. Change the Files of Type combo box to display "ODBC Databases." Click the Machine Data Sources tab and select the name of the ODBC Data Source that you made earlier. A list of MAS 90 table names will be listed from which you can select the ones you want to use. Click on them individually (you can select multiple tables, or Select All if you need them all). Note that some MAS 90 table links may prompt you further for unique key information. Just highlight the fields that will provide a unique key for MS Access to use. Once the tables are linked, you can access them like any other MS Access table.