I'm trying to insert some data from Access to PostgreSQL database, but it's not a simple query, because it's a nested query.
For example :
rst.Open "INSERT INTO car(id, model, color, type) SELECT (id, model, color, type) FROM t_car"
rst is my
t_car is my Access table.
I know it should look like to a Postgresql request and
t_car has nothing to do here, but I don't know how can I specify to this request :
go take informations from my Access table and insert these to my Postgres.
So I'm little bit lost with it, does someone can help me?