[Solved] Import CSV into Base table
Posted: Mon Mar 02, 2015 12:20 pm
How?!
I am working on a very simple DB. List of Items and a table of inspections of these items. I've manually entered a test list of Items but I want to import a rather large set of Inspection records.
I've followed the description of importing given by r4zoli but all I get is the spinning circle of death. When I manage to stop the SCOD, I find an empty table and get an error message in the usual SQL gibberish. (The data is quite clean. Most Comments fields are empty; all other fields are filled with valid values.)
Surely there is an easy method to import data?! Just about every other package I've worked with does.
I have tried both CSV files and Calc files. Similar results in both cases.
Suggestions, pleeeease!!!
I am working on a very simple DB. List of Items and a table of inspections of these items. I've manually entered a test list of Items but I want to import a rather large set of Inspection records.
I've followed the description of importing given by r4zoli but all I get is the spinning circle of death. When I manage to stop the SCOD, I find an empty table and get an error message in the usual SQL gibberish. (The data is quite clean. Most Comments fields are empty; all other fields are filled with valid values.)
Surely there is an easy method to import data?! Just about every other package I've worked with does.
I have tried both CSV files and Calc files. Similar results in both cases.
Suggestions, pleeeease!!!