Error: Output Data (6): Error opening connect string: Can't create Data Source Object
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello! I am trying to output data to an Microsoft Access database and keep getting this error "Error: Output Data (6): Error opening connect string: Can't create Data Source Object". This error appears if I am trying to import data from the Access database as well. I currently have Microsoft Access Runtime 2013 installed as well. Hoping for an easy solution!
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Try installing Access Database Engine 2010 64bit.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Thank you, that helped with importing data from an access database. Now I am trying to pull data from an excel sheet and paste and append it into an access database. When I run my flow, I get this error on the output tool:
Error: Output Data (3): DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: You must enter a value in the 'BilledFees.Fee _Type' field.\3314 = -541331061
Insert into `BilledFees`(`_Bank`,`Fee _Type`,`FEE_ID`,`_Fee Description`,`Alliance`,`_Outlet Account`,`_Outlet Name`,`_Merchant`,`_Merchant Name`,`_Count`,`_Retail Billed Fee`,`_Count1`,`_Retail Billed Fee1`) Values (?,?,?,?,?,?,?,?,?,?,?,?,?)
