error on IN-component in sql-string

[Hans Kemper]

I used the next string in a sql-string in VBA to access a
database other then the currentdb:

INSERT INTO tblSchemes IN 'C:\MY DOCUMENTS\SCHEMES'

The error-message I got (translated from Dutch):

You used the wrong brackets around C:\MY DOCUMENTS\SCHEMES

I tried also (...) {...} [...] "..." , doesn't work

What should it be

Thanks
Hans Kemper

 

[Van T. Dinh]

I normally use double-quotes since Windows uses double-quotes to enclose
pathname.

Perhaps, the problem is that you omitted the extension part of the file name
like ".mdb"???