Problem Creating a Movie Database

[Tyecom]

I am new at SQL & Databases. However, I am trying to create a movie database and have create tables using MS SQL Server 2005. Now I'm stuck trying to import the data into the database. At first I thought I could create the tables and manually enter the data into it. Now it seem that I have to import the data from some data source in order to get it into the database. Can someone explain how this is done? Thanks in advance.

 

[JohnH]

I'm doing it like this with my strongly typed Dataset:

Do "all my source data"
    Dim dr As accountDataSet.transactionRow =  Me.AccountDataSet.transaction.NewtransactionRow
    dr.BookDate = ...some data... 
    dr.TransactionType = ...some data... 
    dr.Description = ...some data... 
    dr.Amount = ...some data... 
    'etc etc populate all fields
    Me.AccountDataSet.transaction.AddtransactionRow(dr)
Loop

This is saved to DB with the standard save button that does the Update through the Tableadapter.