Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Office > Publisher

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 01-20-2018, 02:35 PM
highroadnm highroadnm is offline Windows 10 Office 2016
Novice
 
Join Date: Jan 2018
Posts: 1
highroadnm is on a distinguished road
Default Catalog Merge in Publisher error: "This data source contains no visible tables"

I need some help with resolving this error when attempting to set up a Catalog Merge in a Publisher document. I've found via some online searching that this is a common error across a range of MS applications (Excel, Word, etc.) and database formats (Access, Excel, etc.) when merging data into a document, but I cannot find a solution for this problem specifically for Publisher, and for Catalog Merges. (I'm using Publisher and Excel 2016 versions on Windows 10 Home).



I've set up some Catalog Pages in the document, with a corresponding Catalog Merge Area, and then used Add List > Use an existing list to set up the connection to my remote data source via the Data Connection Wizard. I'm using the ODBC DSN data source type (because this needs to be portable for other users on other computers). My data source is an Excel worksheet. I've gone through all the steps (multiple times, resulting in the same error), and the data connection seems to be set up properly, but at the final step in the Data Connection Wizard, I get an error popup error: "This data source contains no visible tables"

So, apparently this is the cause of the error: "This issue occurs because the ODBC driver used to connect to the data source perceives the worksheets in your Excel workbook as system tables and does not display them. System tables are objects in database files that are not displayed by default."

( help forum citation )


So, the only solution I've found in my searching seems to apply to data merges in Word or Excel (not Publisher), and using the Merge Wizard (which I'm not using because, apparently, the only way to set up a Catalog Merge doesn't use the wizard, but rather the Add List > Use an existing list method.) From that same help forum: "In the Table Options dialog box, click to select the System Tables check box, and then click OK."


I can find no way in Publisher with Catalog Merge to fix this. Is there a solution for this? Or is this function in Publisher - Catalog Merge simply completely broken? Apparently this issue has been present for a number of years, across different versions of Publisher (as well as data merges in Excel and Word), and apparently still not fixed.

Any help is much appreciated.
Reply With Quote
Reply

Tags
catalog merge, catalog pages, publisher

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel seems to create copies of tables visible only when used as a data source catflap Excel 2 01-17-2018 08:04 AM
Bibiography citation gets "Invalid source specified" error Jennifer Murphy Word 9 03-26-2017 11:21 PM
"word was unable to open the data source" error meganadand Mail Merge 5 03-14-2014 01:12 PM
Applying "Paper Source" settings to multiple sections in a mail merge does not apply ChrisC Mail Merge 1 06-18-2012 07:11 PM
Publisher Catalog Merge monkey7759 Publisher 1 01-29-2010 04:53 PM


All times are GMT -7. The time now is 01:10 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft