Excel tabular data import into SQL Server database

Reprint: http://blog.csdn.net/lishuangzhe7047/article/details/8797416

Steps:

1. Select the database to insert-right--task--Import data

2, click Next, select Data source, Excel file path, and version information (Note: Use 2010 and later versions of Office, first convert the format to 03 or 07 format for identification)

3. Select the target database

4, successful execution

5, view import data, can rename

The above is the database import Excel file steps, the database export data similarly.

Many systems have given us a good deal of the import of different format files everywhere. Similar to [adapter], convenient for us to use, we can directly use, we are afraid we do not know that there is this function, wasted time to a line of input data. Therefore, we in the use of a software, first of all to understand the full range of software can achieve what function, do not have, do not know not to.

FAQ: How to display and edit $filterdatabase in Excel (reprint)

When using Excel is clearly a Sheet1, but programming using microsoft.ace.oledb.12.0 can get two table results: sheet1$
Sheet1$filterdatabase Open Excel file look for "name manager" (Formula-name manager) can not find this filterdatabase name, in fact, this is hidden, can be displayed by macro: Open the VB Macro Editor (atl+ F11 or by recording a macro-edit macro to open the editor) paste the following code in:

Sub showallnames ()    For each n in thisworkbook.names        = True    nextend Sub

F5 run, after a successful run, you can delete the code after saving and then close the macro editor and return to Excel.

Reopen the name manager, and you can see all the names at this time.

If you feel that you do not have to delete it directly.

Save the Excel file and solve the problem.

Excel tabular data import into SQL Server database