Alpha Video Training
Results 1 to 3 of 3

Thread: Pre-release 5858 : excel_to_sqlite function

  1. #1
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,693

    Default Pre-release 5858 : excel_to_sqlite function

    Could someone give this function a quick try and see if it works for you? The code I'm using is...

    Code:
    excel_to_sqlite("D:\UserFiles\Test_SQLite_Excel.xlsx","D:\UserFiles\sqliteexceltest.db")
    The error I'm getting is...

    ExcelTOSQLiteError.PNG

    I've tried with both an xlsx and xls file... same error.

    It's unclear from the doc if FieldNames are allowed or what format the Excel and SQLite filenames are to take... there is no example given.

    Xbasic Functions - excel_to_sqlite() - Creates a SQLite database file from data in an Excel file.

    Syntax:

    excel_to_sqlite(c excelfilename, c sqlitefilename)

    Where:

    excelfilename - filename of the Excel file

    sqlitefilename - filename of the SQLite database to create

    Each sheet in the Excel file becomes a table in the SQLite database. The sheetname is the table name. If the first column in each sheet is numeric data and there are no duplicate values in the column data, that column is the primary key of the table in the SQlite database.
    It seems to me that the function is having trouble with something and trying to call a "not_valid" function which doesn't exist... so there are 2 issues here.

    Attached is the xlsx file I'm using. Test_SQLite_Excel.zipThanks.

  2. #2
    "Certified" Alphaholic
    Real Name
    David Kates
    Join Date
    Apr 2008
    Location
    Unionville, ON
    Posts
    7,693

    Default Re: Pre-release 5858 : excel_to_sqlite function

    Today's pre-release 5860 fixes the bug in the excel_to_sqlite function. It now works.

  3. #3
    "Certified" Alphaholic peteconway's Avatar
    Real Name
    Peter Conway
    Join Date
    Oct 2005
    Location
    Melbourne, Australia
    Posts
    2,613

    Default Re: Pre-release 5858 : excel_to_sqlite function

    Cheers
    Insanity: doing the same thing over and over again and expecting different results.
    Albert Einstein, (attributed)
    US (German-born) physicist (1879 - 1955)

Similar Threads

  1. Replies: 2
    Last Post: 10-08-2017, 10:27 PM
  2. How about a release?
    By mdfOffman in forum Alpha Five Version 10 - Desktop Applications
    Replies: 137
    Last Post: 01-09-2010, 04:21 PM
  3. V10 Release
    By xido in forum Application Server Version 10 - Web/Browser Applications
    Replies: 16
    Last Post: 09-06-2009, 09:23 PM
  4. New Release?
    By ab042 in forum Web Application Server v7
    Replies: 16
    Last Post: 12-13-2005, 02:57 PM
  5. RELEASE OF v5 IN UK
    By Peter Lear in forum Announcements
    Replies: 5
    Last Post: 09-06-2002, 12:49 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •