EzGoingKev
Registered User.
- Local time
- Today, 11:14
- Joined
- Nov 8, 2019
- Messages
- 178
I have some code that sets a file location as strPath.
I am trying to use it to append some data from a table in another database to a local table in the db I am working in. I have used:
DoCmd.RunSQL "INSERT INTO BrakeTypeWorking SELECT * FROM BrakeType IN strPath" which gives me a Run-time error 3024: Could not find the file 'C\Users\MyName\Desktop\strPath".
It is not picking up the strPath file name. I am assuming because it is because of the quotes. I have tried it few other ways but nothing seems to work.
Can anyone please advise on what I need to do to get it to run?
I am trying to use it to append some data from a table in another database to a local table in the db I am working in. I have used:
DoCmd.RunSQL "INSERT INTO BrakeTypeWorking SELECT * FROM BrakeType IN strPath" which gives me a Run-time error 3024: Could not find the file 'C\Users\MyName\Desktop\strPath".
It is not picking up the strPath file name. I am assuming because it is because of the quotes. I have tried it few other ways but nothing seems to work.
Can anyone please advise on what I need to do to get it to run?