# Importing ".mdb" files to vision

**URL:** <https://forum.inductiveautomation.com/t/importing-mdb-files-to-vision/66081>\
**Category:** Ignition\
**Tags:** vision\
**Created:** [November 3, 2022, 4:41pm UTC](https://forum.inductiveautomation.com/t/importing-mdb-files-to-vision/66081 "2022-11-03T16:41:29Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Joao\_Pedro\_Almeida](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@Joao\_Pedro\_Almeida](https://forum.inductiveautomation.com/u/Joao_Pedro_Almeida)\
**Post date:** [November 3, 2022, 4:41pm UTC](https://forum.inductiveautomation.com/t/importing-mdb-files-to-vision/66081/1 "2022-11-03T16:41:30Z")

</div>

Hello there !

I have a question and i'd like to get some tips from the community.

I have a computer in my network that generates a ".mdb" file with some informations. I'd like to get those informations and show them on a window created by the Vision.

Is there a way to import this file directly from this PC automatically and extract the information i want to show ?

Thank you for your help !

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [November 3, 2022, 5:00pm UTC](https://forum.inductiveautomation.com/t/importing-mdb-files-to-vision/66081/2 "2022-11-03T17:00:23Z")

</div>

So these are microsoft access files? You can try this way if you have a SQL Server instance running -

> [@Database connection to Microsoft Access 2013 DB](https://forum.inductiveautomation.com/t/database-connection-to-microsoft-access-2013-db/17967/4):
>
> Try installing SQL Server Express and add the MS Access database as a linked server. On the gateway, make a DB Connection to sql express.

Or you can see if there's a jbdc driver for Microsoft Access and directly connecting to Access that way though I can't say how viable this is but perhaps someone else here has done it.

But reading the file directly - unless it's plaintext like a CSV, I am guessing that won't be easy to just put into a vision application dataset/table.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 3, 2022, 5:11pm UTC](https://forum.inductiveautomation.com/t/importing-mdb-files-to-vision/66081/3 "2022-11-03T17:11:27Z")

</div>

I would modify the original MDB to convert its storage tables into "Linked Tables" pointing at a proper database. So that the application seamless puts its data where Ignition can get it.