Processing MS Access .mdb Files

Hi @Ash010110,

If the user of the app needs to provide the app with a file stored on their local machine, you should still have them upload the file using st.file_uploader, but it sounds like you’re going to need to store that file somewhere (rather than just working with the in-memory file-like object). For example, you can store the file in AWS S3 and then pass the path to that file to the pyodbc connector.

Does this mean I don’t need to upload at all? I can just prompt the user of the Web App to provide the filepath to their local .mdb file they wish to parse, and the Streamlit app can “operate” on that file?`

You would only be able to do this ^ if the users are running your app locally on their computers (i.e. it’s not deployed – since a deployed app won’t have access to their local machine).