1. Select the database you want to import, right-click - Task - Import Data
2. Select "Microsoft Excel" as the data source
3. Select the Excel file path to import, select the Excel version 97-2003, and then proceed to the next step, as shown in the figure:
take care Clicking on the next step here may result in an issue where the external table is not in the expected format. Please save the Excel file to be imported as an Excel 97-2003 workbook
4. Select "Microsoft OLE DB Provider for SQL Server" as the target, and then proceed to the next step. As shown in the figure:
5. Next, as shown in the figure:
6. Select the target table you want to import into, and then click "Edit Mapping", as shown in the figure:
7. "Source" refers to the header in the Excel table, "Target" refers to which field in the table to import. Select the corresponding field and click "OK", as shown in the figure:
8. Then the next step is enough.
Related articles
- How does it automatically fill in createTime and updateTime when adding an insert
- What are the performance differences between the string and varchar data types in hive
- Structured Streaming writes data to MySQL and Kafka
- Unity client and PhotonServer server cannot send messages to each other, logs are not printed, and files or assemblies cannot be loaded
- Query the validity period of the HTTPS server certificate for the other party in the Linux environment
- Triton Inference Server - Torch Model Configuration
- ZTree+Java backend data retrieval (including asynchronous) to generate a tree diagram
- QR code: Data Matrix and QRCode
- Opencv cv:: Mat Data Type Summary
- Jpa Repository interface method implementation+custom SQL return map object
Storing data archivedDataWithRootObject unarchiveObject WithData - Apache Server Configuration under Windows 1
- Convert int type data to torch. cuda. FloatTensor type data
- Python reads data from MySQL and SQL Server
- Remote enable server to train model commands in the background [nohup, screen]
- 2022 CCF BDCI Small Sample Data Classification Task Baseline
Latest articles
- Ubuntu decompresses the tar.gz format file
- Ubuntu's XDMCP login to ubuntu desktop crashes
- RunTime Error: cuda out of memory
- Ffmpeg converts a frame from yuv444 format to png format
- Notepad++Theme Change, Highlighting Selected Content
- Record: easycr Error: Could not initialize NNPACK reason Unsupported hardware causing Python program to exit abnormally
- Streamlit installation error resolution
- Resolving Warning for Ignoring Invalid Distribution
- Matplotlib ImportError: DLL load failed: Unable to find specified module
- Python: can't open file '
': [Errno 22] Invalid argument - Executable NotFound: failed to execute 'dot', make sure the Graphviz executors are on your systems'
- Python dictionary application
- Cv2. error: OpenCV (4.5.5) D: a opencv Python opencv Python opencv modules imgproc src imgwarp. cpp: 66
- Python drawing based on f (x) (2D)
- The interval for drawing a histogram in Python must be a saturation integral interval
- PLT.bar Drawing Rules - Taking Drawing Histograms as an Example
- Sort and remove duplicate numbers in C language
- Summary of pedestrian re identification paper
- Unable to boot up when memory is full (Ubuntu)
- Java Spark code error: java. lang. NoSuchMethodError: net. jpuntz. lz4. LZ4BlockInputStream
Hot tags：
java python linux javascript using error android vue.js solution mysql data vue file c++ windows installation configuration c ubuntu method implementation between spring function project spring-boot server system sql database issue c# springboot html docker oracle idea environment command version methods image process resolve uses network excel failed time display