TOPIC: load csv file to database
#442
load csv file to database 3 Years, 9 Months ago
excuse my ignorance. but is there an sqlloader equivalent I can use in Suneido to load a csv file to a table on the database. thanks.
 
 
#443
Re:load csv file to database 3 Years, 9 Months ago
You can use the ImportCSV class to import records from a csv file.
There is an interface to this class in AccessControl if you look under the Global menu button at the bottom of the AccessControl window, there is an Import option. You can easily use AccessControl to "Access" a query by choosing "Access a query" from the IDE menu of the WorkSpace.

Hopefully this is what you're looking for.

Jeff Ferguson
Suneido Software
 
 
Jeff Ferguson
Suneido Software