I have been searching through forums to solve this issue with no luck. I work for a housing finance agency specializing in affordable housing. When we receive applications, we send letters to announce the development to the district's elected officials. We have created a database (Access) to which I would like to link the geocode output and subsequently joined attributes.
I've built a model that takes the geocoded file and joins each feature class's (Districts) attributes to one output shapefile. The model then converts the output shapefile's attribute table to Excel. This Excel file is intended to link to the Access database which contains the names and addresses that correspond to each district/level of government. From Access, the letters are created.
The model works very well however, I cannot get Access to find the file because during the conversion from .dbf to Excel, the Table to Excel tool names the data sheet with the file name, which contains the file extension. For example, I can name the Excel file whatever I like, but the sheet tab will be alloutput.shp with no option to define the sheet name by the user.
I've attached a couple images to show the model and the output. Wondering if there is a workaround here.