error on IN-component in sql-string

  • Thread starter Thread starter Hans Kemper
  • Start date Start date
H

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
 
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"???
 
Back
Top