Re: How do I import many names & addresses in a Letter to a Word D
On Tue, 31 Jan 2006 10:58:29 -0800, Pendragon
<Pendragon@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
>Type: Individual
>ContactFirstName: John
>ContactMI: <blank>
>ContactLastName: Smith
>etc.
>...
><CR>
There are some scripts on my website for handling this sort of thing.
It sounds as if you can get the data into a Word table with field names
in one column and values in the other. If so, and if every record
contains the same fields in the same order, delete the fieldnames column
and export just the data into a text file, e.g.
Individual
John
<blank line>
Smith
...
<blank line between records>
Individual
Mary
P
Evans
...
you can use this VBScript to convert it to a tab-delimited file that
Access can easily import.
http://www.j.nurick.dial.pipex.com/Code/VBS/TallToWide.vbs
Alternatively, if you have or can install Perl on your computer, there
are a couple of scripts for converting files of Name: Value pairs into
delimited files on this page:
http://www.j.nurick.dial.pipex.com/Code/Perl/index.htm
--
John Nurick [Microsoft Access MVP]
Please respond in the newgroup and not by email.
.
Relevant Pages
- Re: Way Kool ! - Wizards of Winter
... good-sized group of people using this controller. ... The scripts are played on a timed event basis so don't run continuously ... addition to Xmas lights it would be great for church & school plays, ... >> John W ...
(comp.home.automation) - Tom-> session hijacking (3)
... Dicky...nice name you picked pretty close to what I picked for him, but John ... Holmes picked something similar for himself so watch out or he could be mad ... option of legally changing....I checked those scripts thoroughly...its only ... the sessions where there's a problem. ...
(php.general) - Re: Critcize my scripts.
... Thank you John and Wiggins for your time and ... > loan tran wrote: ... >> Please critize my scripts and suggest better ways ... > perldoc perlfunc ...
(perl.beginners) - Re: [slrn] Scorefile dummy question
... Subject: John ... Subject: Smith ... scripts can be copy/pasted safely. ... The %BOS and %EOS marks in slrn's scorefile syntax are for the benefit of ...
(news.software.readers) |
|
