SQL: spaces in file names

mlopes1

Registered User.
Local time
Today, 10:09
Joined
Sep 4, 2002
Messages
76
I have following code:

DoCmd.OutputTo acOutputTable, "Exchange", acFormatXLS, "C:\Document Set\desktop\Original.xlt", False


How do I change syntax to handle spaces? Double quotes? Error occurs when code reaches the space between word Document and Set. Thanks as always,

Marco
 
No doubt you've already checked this but is there a folder on C: called 'Document Set'.

JonH.
 
Yes, I check to make sure it existed. Often times that sort of thing is my problem, but this case, path should be correct. I found help on this and it said to use double quotes.. which I have so now I really do not know what to do!
 

Users who are viewing this thread

Back
Top Bottom