can I have more than one Export populate the same Access.mdb

Dave Billnitzer:

Hello alll:

I have a set of Excel reports that are created via an Export to MS Access where some data manipulation takes place, and that in turn is read by Excel to create pivot tables, some charts and some drill-down lists and data points.   I had to do it this way because I kept running into a dead end with Crystal Reports (it just couldn't handle the calculations and manipulation I needed).  Now I need to add some new data to my process; but I want to avoid having to re-create it all from scratch.  I am hoping I can keep Export #1 going to the Access mdb file, and now just addd Export #2 as an additional data source into that same mdb file.   Is this possible?  Or do I have to rebuild Export #1 and incorporate Export #2 into that?   The two exports will have a constituent record ID and gift record ID n common - so I know I can combine both Exports into 1 if I have to, but I really want to avoid that.

I don't believe that you can use another export into the same Access database. Each time you run an export it creates a new file so I think that is what would happen in this case.

What you can do is have a second export write to a second access db.

You can then create a third Access database that has links to each of the other two. Once this is created you don't need to refresh this link database as it will point to the two other database. You just need to refresh these two Access dbs through export. You then connect your Excel file to this third link database and carry on.

David