Bug #92699 Excel tries to sort columns alphabetically before importing data
Submitted: 7 Oct 2018 14:16 Modified: 13 Nov 2018 16:29
Reporter: Kevin Witt Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:8.0.12 & 1.3.7 OS:Windows (Windows 10 x64)
Assigned to: CPU Architecture:Any (64 bit)
Tags: Excel

File: Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

[29 Oct 2018 13:56] Olli Mannisto
Workbench table view

Attachment: Workbenchview.png (image/png, text), 85.71 KiB.

[29 Oct 2018 13:56] Olli Mannisto
Import preview with alphabetic order column names

Attachment: ImportView.png (image/png, text), 26.30 KiB.

[29 Oct 2018 13:57] Olli Mannisto
Excel worksheet after import with data and column names mismatch

Attachment: ExcelImport.png (image/png, text), 53.47 KiB.

[29 Oct 2018 13:57] Olli Mannisto
Capacitor table script

Attachment: CreateTable.txt (text/plain), 1.16 KiB.

[29 Oct 2018 14:00] Olli Mannisto
Data and columns in synch in workbench

Attachment: Workbench_data.png (image/png, text), 25.32 KiB.

[13 Nov 2018 16:26] Miguel Solorzano
Preview

Attachment: 92699_0.png (image/png, text), 64.78 KiB.

[13 Nov 2018 16:27] Miguel Solorzano
Imported

Attachment: 92699.png (image/png, text), 277.77 KiB.

[13 Nov 2018 17:53] Miguel Solorzano
Excel 2016

Attachment: excel_2016.png (image/png, text), 3.44 KiB.