Excel Import Database

First, create a new column in Excel, such as the column name as AB, below your data, such as three-in-one ...

Second, open SQL Enterprise Manager, right click on the database you need to import, select Import data, Next, data source select Microsoft Eccel 97-2000, select Excel file continue next, press down, select sheet1$ or 2,3 see you put the data on that page, Point conversion can be based on your own needs to set some field properties, the purpose of changing the name of the table (if you want to insert data into the existing table, you should choose to append data to the destination tables, but the field name should be the same, if you add a new table, choose to create a destination table), the table name to write whatever you like It's easy to remember. After the setup is finished, the next step is imported. Of course you can preview it first.

Previously written, migrated to this

Original link: http://user.qzone.qq.com/372806800/blog/1336195656

Excel Import Database