RE: output to Access file

[Richard Cotenas <cotenas@xxxxxxxxxx>]

  Sometimes you have to edit the text file--it may have commas in the 
wrong place, or other junk that can cause Access to choke on it. If the 
file is large, and manual editing is too tedious, you might be able
to clean it up using one of the following methods: open the text file in 
a good word processor and use the "find and replace" option. If "find and 
replace" cannot make the kind of fine distinctions that you need, try 
using the macro language that comes with the word processor. A good macro 
language will have "if...else" and looping capabilities that will allow 
you to format each line (a line equals a record, in most cases) any way 
you want. If your macros are still not powerful enough, you can use most 
any good programming language to write a program to clean up the text file 
(I use C, which loves ascii text files). Of course, writing a program is not

a trivial matter, and you have to have a compiler for your system. 

Richard

-----Original Message-----
From: L Parry [mailto:lparry@xxxxxxxxxx]
Sent: Wednesday, December 19, 2001 3:59 PM
To: innopac@xxxxxxxxxx
Subject: output to Access file

I am trying to convert data from our Community Information module to an
Access file.  I have used the create a list function, user selected output
to get the data into comma delimited format, saved it as a .txt file, and
opened that file in Access.  I can't get it to work properly -- no luck
with repeated fields.  Has anyone tried this?  Are there instructions
somewhere in the manual?

Thanks
L Parry, Electronic Outreach Librarian
Wicomico County Free Library
P.O. Box 4148
Salisbury, MD 21802
--
This message was distributed through the Innovative Users Group INNOPAC list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac