![]() ![]() In Access, recreate each of the relationships. In Excel, open the Relationships dialog box by clicking Data > Data Tools > Relationships and note the relationships between the original data sources. In Access, import each original data source as a new table. One way to do this is to use Access to combine the data sources and reproduce them as a query, which you can then import into your workbook. If your workbook contains any such features, you may be able to prepare them for use in earlier versions by combining the feature's data sources into a single table and then using that new table as the data source. Note: You can also use the VLOOKUP function in Excel to address this issue, but the process is somewhat complicated, and becomes more complicated as the number of data sources to combine increases.Įxcel 2010 and earlier versions don't support data features that analyze multiple tables, because those Excel versions don't have a Data Model. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |