This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'm updating a MS Access table from .mdb (2000-2003 format) to .accdb (2007-2016 format) and am having an error occur when moving the date fields.
Here is my example table with two attributes I'm loading into a new Access table:
Recordset1 = '1' (long integer) and Date1 = '11/20/2017' (Date)
Two outputs: Create new table 'tblDateTest' works fine in the AccessDB.mdb format but fails in the AccessDB.accdb format.
Error: Output Data (5): DataWrap2OleDb::SendBatch: Microsoft Access Database Engine: Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done. Insert into `tblDateTests`(`RecordID`,`Date1`) Values (?,?)
Thanks @MarqueeCrew for the reply, I can read it as a string and output it as a string however I need to store the field as a Date in Access. Now I could probably work on the Access side of things and convert it from a string to a date, however I was hoping to avoid that. Are you able to replicate this as well?
I've uploaded a sample workflow to further explain this seemingly simple process. Once the 32-bit MS Access database driver (download AccessDatabaseEngine.exe) was installed and the 64-bit version uninstalled this issue was resolved.