INSERT INTO with a space in the PATH of the database

[melginger]

I have a problem with this INSERT INTO. Everything goes well until we have a space in the path. For instance, the 'program files' folder. That's where the database is. We know that moving the databases to a folder without a space in its path will correct the problem but we want a more long time solution. Thanks

INSERT INTO C:\Program files\Triolet\DATA\rapport.[Absences] (Professeur, [Date], Heure, Opération, Description, Local, NomEtudiant) SELECT Utilisateurs.Prenom + " " + Utilisateurs.Nom, Transactions.DateTransaction, Format(Transactions.DateTransaction, "long time&quot, ...

 

[melginger]

found the answer by myself testing and testing ...

You gotta to put the path between[]:

INSERT INTO [C:\Program files\Triolet\DATA\rapport].[Absences] (Professeur, [Date], Heure, Opération, Description, Local, NomEtudiant) SELECT Utilisateurs.Prenom + " " + Utilisateurs.Nom, Transactions.DateTransaction, Format(Transactions.DateTransaction, "long time&quot, ...