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: | |
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 |
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:
- On *nix platforms use the split command e.g.
split -b 50MB <my_large_archive> <my_split_archive_prefix>
- On windows use WinZip or a similar utility to split the large file
[29 Oct 2018 13:56]
Olli Mannisto
[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 17:53]
Miguel Solorzano
Excel 2016
Attachment: excel_2016.png (image/png, text), 3.44 KiB.