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

– This has been randomly generated using the website Mockeroo.

Films Dataset – 

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

Your email address will not be published. Required fields are marked *

*