[olug] Database export problem
Tim Russell
philodux at yahoo.com
Fri Oct 7 05:51:13 UTC 2005
Eric,
If you know, for example, what data is contained in
the file (for example, the first row, or the first
couple of rows), it shouldn't take much to reverse the
file - assuming, of course, you're just after data and
not interested in maintaining anything else out of the
database (relationships, etc). Being a programmer, my
first instinct is to reach for the compiler.
For example, if you know the first row contains Name,
address, and phone number, and you can reasonably find
those fields within the file, you should be able to
write a program that can scan and extract the data you
want.
Then again, the file format might be way more
complicated than I'm guessing at, and I just don't
know what I'm talking about =) This is occasionally
the case =).
- tim
--- Eric Lusk <wyrmzr72 at yahoo.com> wrote:
> I'm trying to export a proprietary database format
> so
> that it can be read by Excel. The standard format
> of
> the database files gives lots of garbage from
> carriage
> returns, spaces, etc., in Linux or Windoze.
> The program itself has an export option, but that
> only
> exports 3-4 fields to an tab-delimited file. I'm
> going to try and modify the export options tonight
> and
> keep my fingers crossed.
> Anyone else have any ideas about removing the
> garbage
> from a proprietary file? I dread telling the client
> they'll have to manually input 9000 clients....
> TIA
>
>
>
> http://www.ericshaus.com
> Alcohol and Calculus don't mix. Never drink and
> derive.
>
>
>
> __________________________________
> Yahoo! Mail - PC Magazine Editors' Choice 2005
> http://mail.yahoo.com
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug
>
__________________________________
Yahoo! Mail - PC Magazine Editors' Choice 2005
http://mail.yahoo.com
More information about the OLUG
mailing list