The database is a TEXT file, tab delimited - yes a flat file
I have tried importing it into
Paradox, HSQLDB, Open Office Base and Calc, Excel -
I was playing with the spreadsheets thinking at the very least I could
eliminate the fields
I do not want, but the same record/row limit appears to be built into
all of these.
(When I said 65K it's 65,536 records or 1024 x 64 so I guess technically
it's really 64K.)
Joshua has suggested POSTGRESQL, which I am not familiar with at all or
MySQL.
I know a little about MySQL but must admit that when it comes to databases
I hate working on the command line and have not installed MySQL on my
machine yet.
Dennis
James Washer wrote:
First of all... what is an ascii database? Do you mean a simple text file (i.e.
flat file)?
What 64K record limitation are you hitting? With what tool/program are you
hitting this limit?
On Tue, 23 Jan 2007 16:04:36 -0800
Dennis Bagley <[EMAIL PROTECTED]> wrote:
Hey folks,
I have an ascii database containing approximately 190,000 records.
I need to import the data into a dbms, trim out fields I do not need and
extract about 10,000
records.
I keep bumping into a 64K record limitation - is there an open source
solution available
that won't require 3 weeks of studying to use?
Thanks
Dennis
_______________________________________________
RLUG mailing list
[email protected]
http://lists.rlug.org/mailman/listinfo/rlug
_______________________________________________
RLUG mailing list
[email protected]
http://lists.rlug.org/mailman/listinfo/rlug
_______________________________________________
RLUG mailing list
[email protected]
http://lists.rlug.org/mailman/listinfo/rlug
