MS Access | Uncategorized

3. 5 Importing Datasets

Importing Datasets

In this video, I demonstrate how to import data from a text file and give examples of how to append data to an existing table and add data to a new table.

below are the datasets I used in my databases.

Customers dataset –


Download “Customers.csv” Customers.csv – Downloaded 303 times – 9 KB

– This has been randomly generated using the website Mockeroo.

Films Dataset – 


Download “FilmsText.csv” FilmsText.csv – Downloaded 344 times – 10 KB

– This has been edited from a great dataset submitted to Kaggle. The original dataset was of 5000 films taken from IMDB.com

 

Tutorials in the series:

 

Similar Posts

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.