Exporting data from SQL Server to Access using a Linked Server

So I found out the hard way that to export data from SQL Server to Microsoft Access requires that the tables in the Access file have to be created in advance. So instead of using

SELECT * INTO MY_LINKED_SERVER...TABLE1 FROM MY_SQL_SERVER_TABLE

to copy the data and create the tables in the process...you have to use

INSERT INTO MY_LINKED_SERVER...TABLE1 SELECT * FROM MY_SQL_SERVER_TABLE