Question

How can you import data in a Database?​

Answer 1

To import data from an external database:

1.On the Tools menu, point to Import and then click from External Database.

2.In the Database Type dialog box, select a database type.

3.Click OK to connect to the database.

Answer 2

Answer:

SQL INSERT INTO Statement

The INSERT INTO statement is used to add new data to a database.

The INSERT INTO statement adds a new record to a table.

INSERT INTO can contain values for some or all of its columns.

INSERT INTO can be combined with a SELECT to insert records