10-28-2004, 10:52 AM
We had a tool that previously exported data from a Lotus Notes database to a text file. Once the file was exported, I imported it to an access table (Survey) in order to do calculations using a VB Module. The new tool that we have is a DB2 database and instead of being able to export data to a text file, I have to grab the data directly from the tables. I have created a query to pull the data and then load the data into a multi-dimensional array. I use the array to do my calculations as before using the VB module. Is there a way to read the data from the array and store it back to the access table (Survey) that I spoke about above? The elements in the array are in the same position and format as the fields in the table. I need to be able to do reporting for auditing purposes and combine the information from the old tool and the new tool. Is this possible?