Creating ms access database from excel worksheet

In this tutorial it is explained how to create MS Access database from excel worksheet. First, we need to create new MS Access database.

acc01

We need to give full path and type name of new database.

acc02a

And then, click “Create”.

acc03

Then we must witch to “External Data” tab.

acc04

Now, choose “Excel”.

acc05

Final step is to choose option “Import the source data into a new table in the current database”.

acc06

Posted in c-sharp-code-examples

Leave a Reply

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

*