Passing Name value to SQL Statement

[Sully38]

This is probably a simple question: I am looking to copy all the records from one DB and load into another DB, as a simple form of backup, before users "massage" the data.
I thought this was going to be real simple but I can't get Access to allow me to let user select the name of the file. see code below


Dim strName As String
strName = InputBox("Name the Backup file:")

DoCmd.RunSQL ("SELECT test.* INTO strnameTEST IN 'I:\Backup\MFBackup.mdb' FROM Test")

Is this possible, any help is appreciated

 

[Sully38]

Never mind I have found the error in my code and corrected the problem... The stu-pid pills worked well this AM....