[Solved] Importing a huge file....

[Insp Gadget]

I have a txt document with listings of well over 100,000 addresses in my area and wish to import this into Base. I can't open it in Calc first as there are far too many fields. How can I get this into Base????

[Villeroy]

For read-only access:
Copy the file into a dedicated directory.
File>New>Database
[X]Connect to existing database
Type: Text
Point to your directory and specify the details.
Save the database.
Add queries and reports. Forms are not that useful with read-only data.

[Insp Gadget]

Thanks for the reply.

When I did this, I get an error message. "General input/output error" and nothing gets imported. Any ideas???

[Insp Gadget]

OK, I got that fixed and the data imported into my database, but all the columns that were in the txt file and lumpped into one database column if that makes any sense to you. Am I doing something wrong??

If you would like to see the txt docs I am trying to import: http://www.snb.ca/gdam-igec/e/2900e_1.asp and look for Civic Address Database

[Villeroy]

Edit>Database>Properties... tab:"Additional Settings"
Set the delimiters below "Row Format"

[Insp Gadget]

Excellent!! This seems to have worked perfectly!

One more thing. Why does it say that this database does not support relationships?

[RonIA]

Because at this time in reality it is still a big lump of text (like what you originally saw). You will need to import it into a true database engine to use it as a full blown database table, right now OO.oBase is giving doing its best to help you with your text file.

[Insp Gadget]

And how do I go about doing that?

[RonIA]

Not a big expert on OO.oBase, but I'll tell you what I would try.

Create a new database (with the native database engine is OK, in other words, just create a new database)
Have both your new and old databases open on screen at the table screen.
Drag your table based on the text file into the new database.
OPen the resulting table
(You may also have to add an ID field so after it is imported, edit it so it has a field (maybe called ID) that is Integer with Autovalue)
Good luck.

[Villeroy]

And how do I go about doing that?

As Ron already said, drag a table into a newly created database. A wizard pops up where you have to specify the name of the new table and if you want to create a new primary key. If your table already has a column of unique ID numbers or something like that you can later declare this as a primary key. In the second step you have to declare the data type for each column. You can also skip columns or rename columns.
Oh, does the table contain dates? If so, what is the date format (YYYY-MM-DD, DD/MM/YY, MM/DD/YY,...)?

[RonIA]

Thank you Villeroy it had been a while since I had done this.

[Insp Gadget]

Thank you so much! My database is looking much better!!