How to copy data from SQL to Access database?

[merus]

I have a LabView application that needs to get data from an SQL database and store it locally in Access. I was using the SQL statement:
SELECT name.* INTO name IN 'C:/DATA.MDB' FROM name

The SQL driver returns a message saying there is an error near IN.

Is this the wrong syntax? Is there another method to use?

[jbrohan]

In the MySQL manual it speaks of a backup procedure where the contents of the database are written out as a set of insert statements which would effectively re-constitute the file. Maybe the SQL you are using has something similar and the insert should work with Access.