import data from file (SQLite3) thru apple script

Scripting Forums AppleScript Studio & Xcode
#1

Hi all,

We are using SQLite3 for retrieving purpose. We have database in the Excel format. We need to convert Excel format database into SQLite3 database and retrive data from it thru apple script. How to do this?

#2

If you save your Excel spreadsheet as a .csv file you should be able to easily import that file into an sqlite database.

I would use the sqlite database browser to create your databse and import the .csv file. After you get everything set how you want it then start in with applescript.

You can find the sqlite database browser here: http://sqlitebrowser.sourceforge.net/

-Brian