Results 1 to 8 of 8

Thread: Need Formula to get value from sqlite table

  1. #1

    Need Formula to get value from sqlite table



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Sir,

    i have multiple sqlite dbs which contains near 1 lac rows data,

    i received every 4-5 days, some time 6 th day

    db contains 3 columns. => sno, ProductId, Descri.

    now

    i need formula / code to update ProductId with new excel sheet data ==> Description ( getting from sqlite)

    presently i am using vlookup formula to get details

    Requirement:


    it is manual work converting sqlite db to excel instead that i need code / formula/ link directly from sqlite db


    Thank You

  2. #2
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Hi
    please post what you have already achieved showing what went wrong.
    Thank you Ken for this secure forum.

  3. #3
    sir,
    Last edited by myxlguru; 2017-09-01 at 05:39 PM. Reason: short

  4. #4
    sir,

    first convert sqlite to excel
    then using vlookup formula to both files ( 1 file is converted file & another 1 required )

    i required solution to get data from direct sqlite db ( instead of converting it to excel regularly )

    example;

    sno ProductId Descri.

    170001 17301 SansuiMbl
    170002 17305 KrownMbl
    170003 17308 JpnMbl
    170004 17409 JpnTw

    required: (
    =VLOOKUP(A1,Sheet2!A:B,2,0))

    ProductId Descri ( Vlookup result )
    17409 JpnTw
    17308 JpnMbl
    17305 KrownMbl

  5. #5
    Administrator Pecoflyer's Avatar
    Join Date
    Oct 2011
    Location
    Brussels Belgium
    Posts
    1,666
    Articles
    0
    Excel Version
    2010 on Xubuntu
    Please post your sheet. Thx
    Thank you Ken for this secure forum.

  6. #6
    Quote Originally Posted by Pecoflyer View Post
    Please post your sheet. Thx
    attached
    Attached Files Attached Files

  7. #7
    Quote Originally Posted by myxlguru View Post
    attached

    waiting for solution

    experts pls check once

    bcoz sql query working in excel almost sqlite same query
    need how to link ?



    thank you all

  8. #8
    Super Moderator Bob Phillips's Avatar
    Join Date
    Mar 2011
    Posts
    1,652
    Articles
    0
    Excel Version
    O365
    Look at Power Query, sounds ideal for the job.

Posting Permissions

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