🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: adobe.scripting.indesign
Article #18368

Re: Excel import

#18368
From: Olav Kvern
Date: Thu, 03 Apr 2003 05:50
11 lines
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!WebX
References: <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