SQL Sage Note-Import data from Excel into database via access

Import data from Excel into database via access

1. Open access, click "EXTERNAL DATA", select Upload "Excel", select the Excel you want to import, click OK.

2. Select the sheet to upload the data in Excel, click "Next", click "Next", select the list, change the data type (short text type will become nvarchar after import); Click "Next", then "next", Set the name of the table after importing the DB and click "Finish".

3. Right-click on the table name, click "Export", click "ODBC Database", click "New" To create connection, select "SQL Server Native Client 11.0" Next, named Connection Allen Then next; Enter the name of the server, next, enter the username, password next;

4. Select Database Next and select the created connection click OK.

SQL Sage Note-Import data from Excel into database via access