Direct import of CSV to append Base table, not w/Calc

[Don Shapiro]

I have read through these forums and the documentation. It appears that while Base is supposed to equal Access, in importing date it appears to be way behind the curve unless I am missing something here. I hope I am which is why I am writing.

I will have continual CSV files being generated several times a week that need to go directly into an existing Base table. So I am not creating a new table with the import. I am appending the existing data in the table with more data from the next CSV file.

The CSV and the table do not have exactly the same field names.

This was never a problem in Access. You select Import (a function I cannot find in the Base menus), the CSV file, a wizard or filter box comes up to match the CSV field names with the table names (and will remember them for future imports). Then you say okay and viola, your CSV data is in the table as additional records.

Please tell me how I do this in Base. No, I cannot use CaLc as an intermediary nor spend time manually copying and pasting data from the CSV file into the database. This is 2009, not 1995. Those extra steps have no place in DB operations today. I need to do these imports fast (maybe 30 seconds max) from the time I access the CSV until the new records are in the Base table. That would have been a no brainer in Access. Do I need to buy Access or can Base do the job it's supposed to do?

Thanks,

Don

[Villeroy]

It appears that while Base is supposed to equal Access,...

Not at all. This is the worst misunderstanding about Base.
The underlying HSQLDB can import csv into database tables. You can access the underlying HSQLDB of a native Base database through the command line interface Tools>SQL...
Base Vs MS Access ?
Re: Using Base as editable front end for CSV