Forum Discussion
Pivot-Tabelle mit Externer (lokaler) Datenquelle verbinden
Eckdaten: Excel für Mac 16.16.10 OS: 10.15.3 Catalina Ich möchte für meine PivotTables eine externe Datenquelle (lokale .csv-Datei) auswählen. (siehe Bild-1) Beim Klick auf "Verbindung auswähle...
danke, aber das klappt leider auch nicht. Ich bekomme gar nicht die Möglichkeit, dass ich eine lokale Datei auswählen kann.
andreasbehr Because you don't have the ODBC driver installed. I get the exact same message on my system. You need the driver first before you can start connecting to externa data sources.
which driver did you install? I downloaded this one here: http://www.odbcmanager.net/about.php but it didn't work for me.
Can you connect to a local file with the right ODBC driver?
andreasbehr Sorry, can't help you here. Don't use it myself. Just wanted to point you at the information hoping you could figure it out.
- I know that's something to do with the OCBD Drive. It looks completly different on my computer than like the hundrets of how-to's I read in the internet.