Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel export to Access | Excel Programming | |||
Export to Access from Excel | Excel Discussion (Misc queries) | |||
Export from Access to Excel | Excel Programming | |||
export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
Export from Access to Excel | Excel Discussion (Misc queries) |