# Can't load sqlite table to dataframe

**URL:** <https://discourse.julialang.org/t/cant-load-sqlite-table-to-dataframe/100911>\
**Category:** New to Julia\
**Tags:** question\
**Created:** [June 27, 2023, 6:16pm UTC](https://discourse.julialang.org/t/cant-load-sqlite-table-to-dataframe/100911 "2023-06-27T18:16:29Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![kv-gits](https://sea2.discourse-cdn.com/julialang/user_avatar/discourse.julialang.org/kv-gits/32/51093_2.png) [@kv-gits](https://discourse.julialang.org/u/kv-gits)\
**Post date:** [June 27, 2023, 8:11pm UTC](https://discourse.julialang.org/t/cant-load-sqlite-table-to-dataframe/100911/2 "2023-06-27T20:11:55Z")

</div>

SQLite.DBInterface.execute… instead of SQLite.execute works, but it is very confusing

> [@SQLite/DBInterface confusion](https://discourse.julialang.org/t/sqlite-dbinterface-confusion/38458/5):
>
> You could try: dump(SQLite.execute(db,"select \* from Test1")) That will show you the object. My guess is they implemented a show method for whatever that method returns…and it’s not showing much. Again looking at the code maybe try: a = SQLite.execute(db,"select \* from Test1") getvalue(a, 1, Int) Not sure if getvalue() should be prefixed with SQLite.

---

_[View the full topic](https://discourse.julialang.org/t/cant-load-sqlite-table-to-dataframe/100911)._