Hi Actually it wasn't the Spaces in the Column Names it was the names themselves. I added a 'W' in front of all the column names and the insert started working.
Interesting, so does MS know when it is not one of there products trying to insert into fields named 'To' or 'From' hummmm.... Ben Johansen - http://www.pcforge.com Authorized WiTango Reseller http://www.pcforge.com/WitangoGoodies.htm latest beta downloads @ http://www.witango.ws -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Thomas Ferguson Sent: Monday, July 29, 2002 12:07 PM To: Multiple recipients of list witango-talk Subject: RE: Witango-Talk: Inserting into MS Access :-( spaces will definitely do it... -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Ben Johansen Sent: Monday, July 29, 2002 2:58 PM To: Multiple recipients of list witango-talk Subject: Witango-Talk: Inserting into MS Access :-( Hi all, Does anyone know the secret to inserting data into MS Access from Witango.. This is for the Archive and the table was created from an Outlook() import from Outlook Column name examples: To text type >From text type Subject text type Has - Attachments Boolean type (yes spaces in the name) Received DateTime type Contents Memo type Is it the spaces in the column names? Is it the Boolean? Is it Reserved words? Should I move the archive to MySQL :-) Ben Johansen - http://www.pcforge.com Authorized Witango Reseller http://www.pcforge.com/WitangoGoodies.htm Latest downloads & List Archives @ http://www.witango.ws ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body ________________________________________________________________________ TO UNSUBSCRIBE: send a plain text/US ASCII email to [EMAIL PROTECTED] with unsubscribe witango-talk in the message body
