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 81 times – 9 KB

– This has been randomly generated using the website Mockeroo.

Films Dataset – 

Download “FilmsText.csv” FilmsText.csv – Downloaded 107 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:

 

Posted in MS Access, Uncategorized.

Leave a Reply

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