Skip to content

Instantly share code, notes, and snippets.

@marcorodas
Last active January 28, 2019 04:29
Show Gist options
  • Select an option

  • Save marcorodas/4b912e59df27d2afa3d602960da5b92f to your computer and use it in GitHub Desktop.

Select an option

Save marcorodas/4b912e59df27d2afa3d602960da5b92f to your computer and use it in GitHub Desktop.
EXCEL CSV
TRUNCATE TABLE dua_xlsx;
LOAD DATA
LOCAL INFILE 'C:\\Users\\skynet\\AppData\\Local\\Temp\\dua_xlsx.csv'
INTO TABLE `file_collection`.`dua_xlsx`
CHARACTER SET latin1
FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\r\n'
IGNORE 1 LINES;
SELECT COUNT(*) FROM dua_xlsx;
Install-Module -Name ImportExcel
Import-Module ImportExcel
$in = '.\Trabajada - Importaciones Formulas & Suplementos v8.xlsx'
$out = $env:TMP + '\dua_xlsx.csv'
Import-Excel -Path $in -WorksheetName Data -StartColumn 1 -EndColumn 33 -NoHeader | ConvertTo-Csv -NoTypeInformation | Select-Object -Skip 1 | Set-Content $out
@marcorodas

marcorodas commented Jan 28, 2019

Copy link
Copy Markdown
Author

Use UNIX file command to get the file encoding charset. scoop install file
... -Encoding UNICODE encodes to Little-endian UTF-16 Unicode charset
... -Encoding ASCII (default) encodes to Windows codepage 1252 charset which is equivalent to MySQL's latin1 charset

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment