Excel table data import in database tables

Excel table data is imported into a database table

Import data from a database table template into an ' Excel ' table into the corresponding table in the database (note: The primary table and the relationship from the table to be piloted ' main Table ' in the import from the table)

Process: Import through the database tool-first imported as a temporary table, inserted into the formal table. The statements are as follows:

-- yk_typk inserting Data Insert  into YK_TYPK        -- insert ' YK_TYPK (Tong Supplies Library) ' Data select* from sheet1$_ Typk_caoyao------------------------------------------------------------

Excel table data import in database tables