1 person found this helpful
Yes it can be done with various workflows: from placing and styling to "dynamic" data merge, etc. Depending on the project and chosen workflow will dictate what data file should be used...
Thanks Grant, I will probably need to bring in an expert InDesigner to help me set up my initial document.!
I will probably need to bring in an expert InDesigner to help me set up my initial document
Prob better: altho its not that hard, there are a lot of "things" you need to know how to do (errr obv...) from how you create the ID file to importing the data, no matter what workflow suits the project best.
There are two approaches that come to mind in terms of automating updates, and both will require you to do some research, and probably testing on a small sample to see which looks like it would work better.
The first would be to export the Access data into an Excel spreadsheet and to place named ranges from the spreadsheet into ID as tables. To preserve formatting you can either do all the formatting in the spreadsheet, or you can use table styles. The tricky part about this texhnique is you must set ID, in the preferences, to link to text and spreadsheet documents when importing BEFORE you place the spreadsheet (you can turn that back off afterward), and you must update the same spreadsheet for ID to recognize the changes and ask to update the link.
The second would be to export a text file from Excel and set up a Data Merge project. This would be attractive only if you have repetious data structures where a single line in the text file contains all the information for a single product, and you have many products, and you want eiter one per page, or lists of many per page. Depending on how the merge tempalte is set up it can update as the data source document is changes, or you can run the merege over again with a new source.
There are also a number of catalog plugins from third parties which have very sophisticated database connectivity, if you want to spend some money.