Hi.

I create SQL queries on my wesite and I put them in files for the user (.sql, but any file type would be possible). I would like them to easily import them in their MS Access.

I can copy the SQL-line and paste it in Acces' Design View -> Query menu -> SQL Specific -> Select Union. But I think that is too complicated. I would just like to import them from a file to make it easier for the user of my site.

Is that possible?

Not directly. but as the file is text it would be a trivial process to open the file read in the SQl and add it to the the query definitions

I don't understand what you mean.

So there is no way to import a query directly from a file?