🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.scripting.indesign
Article #20035

Re: Database Driven Catalog - ???

#20035
From: maxdunn
Date: Wed, 13 Nov 2002 20:16
9 lines
1699 bytes
It is quite possible to create a data-driven catalog in InDesign from Access. There are several ways it can be done, including: 
1. Opening the database from VBA and iterating through a recordset, adding content to the InDesign file as you go. 
2. Outputting tagged text files from Access and placing them in an InDesign template. 
3. Outputting XML from Access and placing it in an InDesign template. 

Of these, I think 2 is easiest to start with and 1 is ultimately the most powerful. XML is wonderful, but it can add an intermediate step that really isn't essential: I would tend to use the third method only if the data is already XML. 

To learn about Access and VBA (I would say DAO is easiest unless you plan to move to SQL Server some day, then ADO makes more sense) see the Access newsgroups <http://communities.microsoft.com/newsgroups/default.asp> (or you can subscribe to them in your newsreader), for example: 
microsoft.public.access.modulesdaovba
Technical Details
Message-ID: <1de69529.0@WebX.la2eafNXanI>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX
References: <1de69529.-1@WebX.la2eafNXanI>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: f939a,4348409c0a586298
X-Google-Attributes: gidf939a,public
X-Google-ArrivalTime: 2002-11-13 12:40:04 PST
From: maxdunn <maxdunn@siliconpublishing.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!WebX
Newsgroups: adobe.scripting.indesign
Subject: Re: Database Driven Catalog - ???
Message-ID: <1de69529.0@WebX.la2eafNXanI>
Date: Wed, 13 Nov 2002 12:16:55 -0800
References: <1de69529.-1@WebX.la2eafNXanI>
Lines: 18
MIME-Version: 1.0
Content-Type: text/plain; charset="ISO-8859-1"
Content-Transfer-Encoding: 8bit