Hi!

Problem for today - import CSV file formatted like Table to Excel Sheet.

It is possible to copy connection string from power query table to excel without PQ to query table?

I have connection string in Query Table in Excel which is working but without polish signs (encoding utf 8):

definition of connection:
DBQ=L:\;DefaultDir=L:\;Driver={Microsoft Access Text Driver (*.txt, *.csv)};DriverId=27;Extensions=txt,csv,tab,asc;FIL=text;MaxBufferSize=2048;MaxScanRows=25;PageTimeout=5;SafeTransactions=0;Threads=3;UserCommitSync=Yes;
Command text:

SELECT Pesel_Aktywni.`Ď»ŻNAZWISKO_IMIE`, Pesel_Aktywni.JG_SKRĂŁT, Pesel_Aktywni.PESEL, Pesel_Aktywni.SYSTEM
FROM Pesel_Aktywni.txt Pesel_Aktywni
SKRĂŁT = SKRÓT in Polish and MS Query treating CSV like ANSI or OEM encoding...

I need UTF 8 and Power Query is very useful here.
Question is it is possible to move connection string from MS PQ to EXcel Ms Query table?

Thank You for help,
Jacek