Analytic Lunatic
Reputation: 3934
Make Connection to AS400 in Excel to update 2 worksheets with data from 2 Tables?
I have an Excel workbook with several worksheets. I need to connect to AS400 and make it to where when users click refresh, 2 worksheets ([Feedname] & [Feedprod]) are updated with data from 2 tables on the 400.
Anyone know how to do something like this?
Upvotes: 0
Views: 462
Answers (1)
Buck Calabro
Reputation: 7648
ODBC is the typical way this is done. There is an ODBC driver that comes with [IBM i Access].1
Upvotes: 2
Related Questions
- Refresh Excel connections
- Updating and Existing OLEDB Connection using VBA
- Choose AS400 query records directly from Excel
- Refreshing multiple data connections simultaneously in Excel
- Updating data base from an Excel workbook with another Excel workbook
- VBA: Remotely refresh queries in another workbook
- Use VBA to make Excel refresh data from source
- Dynamic Refreshing of Data connections in Excel using VBA
- Connect to another data source
- Interfacing Access Databases to Update Excel Spreadsheets