Exporting Access Query to HeidiSQL

[expired user #9696]'s profile image [expired user #9696] posted 8 years ago in General Permalink

Hey all - I am new to the HiediSQL system but I am looking to link a query I have created in my Access Database to a HeidiSQL database. It is just a one column table with over 100,000 records. Even if I could just copy in the data from the table and then update it daily that would work. Preferably I would like a linked table though.

Thanks in Advance.

[expired user #9749]'s profile image [expired user #9749] posted 8 years ago Permalink

Hello,

you seem to be confusing the query software with database software.

When you run a query from MS Access, you most likely access the same MS Access database.

When you run a query from Heidi SQL, you must access some database which you had created a connection to, before. HeidiSQL is not a database engine, it's just a management software for some existing database engine.

HeidiSQL can manage PostgresQL, MySQL (or its fork, MariaDB) and Microsoft SQL Server. You cannot use HeidiSQL to run a query against MS Access database.

Perhaps we misunderstood you, so please rephrase your question.

Please login to leave a reply, or register at first.