multiple sql inserts in Access?

[Keita]

Hi everyone,
I have a txt file where my sql insertions are (Insert into XXX values XXX; Insert into YYY values YYY and so on), but when inserting them in SQL view from Access, it sends an error saying that only one query can be made (characters found after the sql statement)...is there any way to make multiple sql inserts without making any macro just as if copy-pasting multiple queries as in SQL Server? any comment will be appreciated

[MMcCarthy]

Hi everyone,
I have a txt file where my sql insertions are (Insert into XXX values XXX; Insert into YYY values YYY and so on), but when inserting them in SQL view from Access, it sends an error saying that only one query can be made (characters found after the sql statement)...is there any way to make multiple sql inserts without making any macro just as if copy-pasting multiple queries as in SQL Server? any comment will be appreciated

You can do this in VBA but not in the query window.