Article View: adobe.scripting.indesign
Article #18368Re: Excel import
From: Olav Kvern
Date: Thu, 03 Apr 2003 05:50
Date: Thu, 03 Apr 2003 05:50
11 lines
1482 bytes
1482 bytes
Michael-- While you can write an Access VBA macro to transfer the text from a database field to an InDesign text frame, it'll be a very slow process. I think you'd be writing a macro that exports the record contents as an InDesign tagged text file and then places that file in the InDesign layout. Placing pre-formatted text is about a billion times faster than entering and formatting text one field at a time. Another thought would be to have the Access database emit XML--I don't remember if Access can do this, but it's easy enough to write VB/VBA for (as XML is a text file). I've got to find a copy of Access so that I can help with questions like yours--I only have an old version of FileMaker (most of the time, when I need a database, I write it myself in VB<g>). Thanks, Ole
Technical Details
Message-ID:
<1de88449.4@WebX.la2eafNXanI>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!WebXReferences:
<1de88449.-1@WebX.la2eafNXanI>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: f939a,443dc24c5e53e228 X-Google-Attributes: gidf939a,public X-Google-ArrivalTime: 2003-04-02 22:14:04 PST From: "Olav Kvern" <okvern@adobe.com> Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.online.be!newsfeed01.sul.t-online.de!t-online.de!WebX Newsgroups: adobe.scripting.indesign Subject: Re: Excel import Message-ID: <1de88449.4@WebX.la2eafNXanI> Date: Wed, 2 Apr 2003 21:50:24 -0800 References: <1de88449.-1@WebX.la2eafNXanI> Lines: 20 MIME-Version: 1.0 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: 8bit