Export from excel to Access
I have ste up code to export excel data to a table in access 2007. It works
in Access 2003 but not 2007. The following extract fails with the message "Run-Time Error '3343'. Unrecognized database format "C:\Documents and Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb" Dim db As Database, rs As Recordset, r As Long Set db = OpenDatabase("C:\Documents and Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb") It seems that DAO and access 2007 don't mix! |
Export from excel to Access
Access is no tbackwards compatable. Usually when you install a newer version
of access you have to upgrade the database to work. I would go into your excel VBA menu tools - References and use these two version of the libraries 1) Micorsoft Access 11.0 object library 2) Microsoft ActiveX Data Objects 2.8 library These libraries are the standsrd ones I use with Excel 2003. I don't know what 2007 uses. "GreatCrosby" wrote: I have ste up code to export excel data to a table in access 2007. It works in Access 2003 but not 2007. The following extract fails with the message "Run-Time Error '3343'. Unrecognized database format "C:\Documents and Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb" Dim db As Database, rs As Recordset, r As Long Set db = OpenDatabase("C:\Documents and Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb") It seems that DAO and access 2007 don't mix! |
Export from excel to Access
I think you can find pretty much whatever you want right he
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm HTH, Ryan--- -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "joel" wrote: Access is no tbackwards compatable. Usually when you install a newer version of access you have to upgrade the database to work. I would go into your excel VBA menu tools - References and use these two version of the libraries 1) Micorsoft Access 11.0 object library 2) Microsoft ActiveX Data Objects 2.8 library These libraries are the standsrd ones I use with Excel 2003. I don't know what 2007 uses. "GreatCrosby" wrote: I have ste up code to export excel data to a table in access 2007. It works in Access 2003 but not 2007. The following extract fails with the message "Run-Time Error '3343'. Unrecognized database format "C:\Documents and Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb" Dim db As Database, rs As Recordset, r As Long Set db = OpenDatabase("C:\Documents and Settings\Peter\My Documents\NEMS\Databases\Backends\NEMS Members_be.accdb") It seems that DAO and access 2007 don't mix! |
Export from excel to Access
Did you ever get an answer for this? I am having the same problem and can not figure it out. *** Sent via Developersdex http://www.developersdex.com *** |
All times are GMT +1. The time now is 01:12 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com