SQL: spaces in file names (1 Viewer)

mlopes1

Registered User.
Local time
Today, 19: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
 

JonH

Registered User.
Local time
Today, 23:09
Joined
Oct 11, 2002
Messages
38
No doubt you've already checked this but is there a folder on C: called 'Document Set'.

JonH.
 

mlopes1

Registered User.
Local time
Today, 19:09
Joined
Sep 4, 2002
Messages
76
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

Top Bottom