Gina Hoopes
hoopesg at hotmail.com
Sun Dec 14 12:19:47 CST 2003
Oh, how I wish that would have solved it! I ran a make-table query on my query so I could change that field name to Descrip (and changed the references to look at the table) but I got the same error. :( Thank you, Gina From: Gustav Brock <gustav at cactus.dk> Reply-To: Access Developers discussion and problem solving<accessd at databaseadvisors.com> To: Access Developers discussion and problem solving<accessd at databaseadvisors.com> Subject: Re: [AccessD] Export to multiple Excel sheets Date: Sun, 14 Dec 2003 18:36:18 +0100 Hi Gina > When it reaches cnn.Execute strSQL, I get an error that says "The SELECT > statement contains a reserved word or an argument name that is misspelled or > missing, or the punctuation is incorrect." That word could very well be "Desc". /gustav > strSQL = "SELECT Area, CenterNo, AcctNo, Desc, Actual03, Budget04, _________________________________________________________________ Tired of slow downloads and busy signals? Get a high-speed Internet connection! Comparison-shop your local high-speed providers here. https://broadband.msn.com