[Solved] Loading very large CSV files into Base

[laughterbob]

Hello,
I am trying to load a large CSV file (>10MB) into Base. The file is too large for Calc (too many records).
I have studied the posts in this area but cannot find a solution to my problem.
Everything I try either attempts to use the Calc filter (which fails to handle the number of records and leaves me with a truncated dataset) or nothing happens.

The first line of the file has Header labels.
Once the data has been loaded, I want to set the type of some of the fields (e.g. change from text to numeric) and perform the kind of data sorting and enquiries that are common with spreadsheets.

I figure I am missing something obvious but can't seem to find an answer.
Thanks, Bob.

[FJCC]

This tutorial describes how to create a table and then load it with data from a csv file.

[laughterbob]

Thank you. Bit of a problem until I realised I did not have a primary key field, then a bit of adjustment of string length and whoopee!
Cheers, Bob.