excel help give OleDbException Syntax error in INSERT INTO statement


Author
Message
Jocelyn Dagrain
Jocelyn Dagrain
StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)StrataFrame Novice (68 reputation)
Group: Forum Members
Posts: 20, Visits: 127
Bonjour when I try to export using the excel helper I recieved this error message

OleDbException
  Syntax error in INSERT INTO statement.

Source     : Microsoft JET Database Engine

NB. the excel file is created but with only the header

Thank you

Reply
Edhy Rijo
E
StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)StrataFrame VIP (6.4K reputation)
Group: StrataFrame Users
Posts: 2.4K, Visits: 23K
Hi Jocelyn,



Don't know if this is relevant or no, but if you are testing on a 64bit OS it could be possible that the OleDB driver being used is just for 32bit OS, if that is the case you will need to compile your project specifically for x86 instead of "AnyCPU" the default value and test again.

Edhy Rijo

GO

Merge Selected

Merge into selected topic...



Merge into merge target...



Merge into a specific topic ID...





Similar Topics

Reading This Topic

Login

Explore
Messages
Mentions
Search