How to Import Data from a Flash Drive

Question

I am brand new to Access! I hope to be working with 13 states of the union. I am very familiar with computers, but not Access.

In what I am planning to accomplish I will be receiving Flash Drives from outside sources. They will have a folder with data in it. They all will be an Access Table inside a folder from each statte.

I hope you are a little patient with me, this is a whole new world of programming for me. My biggest problem may be the security.

There are a lot more areas to grant permissions, so I am hoping that Barnes and Noble will have some books available.

Several states of the union will no longer be doing much with e-mails, too much ransomware. Everything I will be receiving will be from the postal system.

FYI: Four states of the union are now doing this.

I have created a new database with a table in it. I need to start by linking to the table on the Flash Drive that I have transferred to my computer. How do I import the data from the field on my Flash Drive table (which will be happening a lot) to the new table in my new database.

Thank You

Old NASA Kid

Answer 1

Hello there,

You can bring data from one Access database into another in many ways. Copying and pasting is the simplest method, but importing and linking offer you better control and flexibility over the data that you bring, and over how you bring that data into the destination database.

This article explains how to import or link to data in another Access database.

https://support.microsoft.com/en-us/office/import-or-link-to-data-in-another-access-database-095ab408-89c7-45b3-aac2-58036e45fcf6

https://support.microsoft.com/en-us/office/introduction-to-importing-linking-and-exporting-data-in-access-08422593-42dd-4e73-bdf1-4c21fc3aa1b0

Hope this resolves your Query !!

--If the reply is helpful, please Upvote and Accept it as an answer--