This scripts don't contain error checking.ĮxtractFiles.zip This contains all the code files (3.19 KiB) Downloaded 1215 timesĬode: Select all SELECT DLOOKUP("CATEGORYNAME","CATEGORIES","CATEGORYID=6") It assume that the map name is a name of a mdb database who is on level higher. csv it makes a new file with the table definition. This is also working in the map from where you start this script.įor each file who ends on. It make a new map in this map and move there the empty files to. This script is working in the map from where you start it up. When you see you have a lot of empty files then MoveEmptyFiles can move all files without data to an other map. When you use a text database then you can read now all the file who are extract and are in a single map. I think the best method is store the mdb files you have in a separate map with only mdb files. It use the mdbtools.ĮxtractData : extract the files from the database This move files with only one to a map emptyfileĬode: Select all This files are handling a mdb database. # It is not important where this script is.ĭirNaam="$.csv" Then the files are stored in the same map. # start this script up from the place where the MDB files are. #When you still have MS Acces use MS Acces for exporting dat to a CSV.
#I have select this method there it was the most easy way to import data in CALC. #For each MDB file there is made a new MAP. #The script take care all MDB files are exported as a CSV. #c) Numbers are exported with a point as decimal separator #b) Date are exported in year month day style for using in HSQLDB style # the purpose is that this scrip export all files from the mdb database as CSV # this script is only working with linux.