Blue Prism® Guide to OLEDB
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
16-06-22 09:09 AM
I am working on the above course, i am working through the options for using SQL as it is something that will be integral to a project myself and my colleague will be working on later this year. However i cannot get the INSERT INTO part working, i have copied the example one and adjusted the sheet names to match and data columns to match but it keeps coming up with a Syntax error, i have tried using every way i can think to alter the SQL string to work but each time it does not seem to happen. I dont have much experience using SQL language so iam worried i'm a bit stuck since i have been trying since yesterday. Could anyone offer some advice on how to get this to work?
1 REPLY 1
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
17-06-22 06:48 PM
Hi John
Can you share an example of the sql you are trying to run? also have you checked you are setting the connection to the database correctly?
Can you share an example of the sql you are trying to run? also have you checked you are setting the connection to the database correctly?
