[AccessD] Export to multiple Excel sheets

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



More information about the AccessD mailing list