I have a spreadsheet which is currently in OpenOffice ods format but obviously can easily be saved in another format should I need to.
The spreadsheet holds roughly 6200 rows with 8 columns. I'd like to import 6 of those columns into an SQLite database and more to the point, do it automatically/programmatically rather than by hand.
There is another difficulty (it's difficult for me, it might not be for you!) is that I want the tables to be created from the names in column 3. Some of those columns are numerical and SQLite doesn't appear to like that.
The columns look like this :- Name1 Number Name2 Y/N Where Notes Unwanted1 & Unwanted2
For Name2, the rows repeat so there might be half a dozen of the same names, like 1648, 8Sail, Abbeydale against the rows in Name1.
Is there somehow I can run a program, Perl, Python or whatever to extract the data and automatically squirt it into a database?
I've searched online for something to help and did grab a Python script but it doesn't work for me and as my Python skills, like all my other programming skills amount to zero, I'm stuck, hence the question here.
I'd appreciate any help or pointers you could give.