Need Formula to get value from sqlite table

M

myxlguru

New member
Joined
Aug 31, 2017
Messages
10
Reaction score
0
Points
0
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
 
Hi
please post what you have already achieved showing what went wrong.
 
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
 
Look at Power Query, sounds ideal for the job.
 
You must log in or register to reply here.
Back
Top