No video

Excel Tutorial (Connect to Postgres Database)

  Рет қаралды 23,532

Keitri TV

Keitri TV

Күн бұрын

Postgres ODBC Driver
www.postgresql...

Пікірлер: 17
@chuckbecker4983
@chuckbecker4983 4 жыл бұрын
Thank you. This added to my knowledge of how to connect to a PostgreSQL database from Excel.
@brianfandy
@brianfandy 2 жыл бұрын
thanks you. this tutorial help me to solve my work problem
@Momo-bb2fn
@Momo-bb2fn 3 жыл бұрын
How do I find my connection string or how do I set it up?
@freemusicscore7281
@freemusicscore7281 3 жыл бұрын
for those can't see Postgre SQL ANSI(x64) 1:33 --> I used the 64bit installer and it showed.
@Samuftie
@Samuftie 2 жыл бұрын
thank you so much
@user-xs5mj1ec1q
@user-xs5mj1ec1q Жыл бұрын
Thank you!
@harisaim
@harisaim 4 жыл бұрын
Thank you so much for video
@jamesthomas3959
@jamesthomas3959 Жыл бұрын
sorry what exactly are we downloading because I see a bunch of files on PostgreSQL server . How do i download all of it.
@praveenakumar7982
@praveenakumar7982 5 ай бұрын
Exactly I am facing same issue....Did you find any solution of it ?
@rabiukhalid3907
@rabiukhalid3907 Жыл бұрын
How do I get the connection strings? The initial catalogue? So annoying!
@ilhamakbar1984
@ilhamakbar1984 3 жыл бұрын
And how if we want to export excel data to become postgresql databse, my goal is i can show my excel in grafana
@granand
@granand 3 жыл бұрын
Thanks but please can you help, have you tried creating data validation from postgres tables on a column in excel .. here is the problem statement, Until we develop front end, we want to continue using excel but people are entering wrong data causing us huge issues. So can you give some Ideas, like say excel from a sharepoint which is always connected to postgres .. Then for data we want it to be auto populated or use only data which is showing up from postgres database, for that each column in excel will read table of postgres as a data validation so user cannot enter any random data. Is it possible
@NgocLaMinh
@NgocLaMinh Жыл бұрын
Hi Sir, my question is: "where is the K3POSDB come from? How can I get those string from my pgSQL?" And the second question is: "What if the pgSQL is running on my localhost? Just input the IP of the localhost or input something else?"
@KeitriTV
@KeitriTV Жыл бұрын
K3POSDB is the name of the database created inside postgres. If it is running in localhost, you can use localhost then the defaul port 5432
@sainathg3339
@sainathg3339 Жыл бұрын
Even i got confused with that, watch complete video and you would understand that its a database name
@Momo-bb2fn
@Momo-bb2fn 3 жыл бұрын
im SOOOO confused
@Momo-bb2fn
@Momo-bb2fn 3 жыл бұрын
I’m STILL SOOOOOO confused.
Webinar: What is Open Database Connector (ODBC)?
33:27
UK DATA SERVICE
Рет қаралды 114 М.
Ik Heb Aardbeien Gemaakt Van Kip🍓🐔😋
00:41
Cool Tool SHORTS Netherlands
Рет қаралды 8 МЛН
Can This Bubble Save My Life? 😱
00:55
Topper Guild
Рет қаралды 71 МЛН
Schoolboy Runaway в реальной жизни🤣@onLI_gAmeS
00:31
МишАня
Рет қаралды 2,8 МЛН
Little brothers couldn't stay calm when they noticed a bin lorry #shorts
00:32
Fabiosa Best Lifehacks
Рет қаралды 19 МЛН
Import Excel spreadsheets into your database using PostgreSQL
7:33
Power Query. ВПР без Merge / Join
9:03
Товарищ Excel - Power Query, Power Pivot, Python
Рет қаралды 6 М.
PostgreSQL vs MySQL
6:33
IBM Technology
Рет қаралды 323 М.
Connect to MySQL from Excel (Complete Guide)
4:49
TeachExcel
Рет қаралды 33 М.
Use Excel to Connect to SQL Server Data
13:51
Anthony Smoak
Рет қаралды 102 М.
Introduction to PostgreSQL Tutorial - Part 1
17:13
Database Star
Рет қаралды 38 М.
Accessing APIs using Excel
15:33
Skills With Sid
Рет қаралды 19 М.
I've been using Redis wrong this whole time...
20:53
Dreams of Code
Рет қаралды 353 М.
Import CSV file into PostgreSQL with PgAdmin
5:26
Raili Taylor
Рет қаралды 65 М.
Ik Heb Aardbeien Gemaakt Van Kip🍓🐔😋
00:41
Cool Tool SHORTS Netherlands
Рет қаралды 8 МЛН