| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export/deletingdata from Excel to access
In order to export data from Excel to Access, Ihave to
have Microsoft ActiveX Data obects 2.7 Library selected. In order to delete the table data in Access before exporting the new data, I have to have MS DAO 3.6 Object Library selected. Whne I have both selected, the delete code won't work. When I get to Set rs = db.OpenRecordset("test") I get an error message that says "type mismatch" Can anyone help me out? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Data Export from Access to Excel | Excel Discussion (Misc queries) | |||
| Export Excel File From Web or Access | Excel Discussion (Misc queries) | |||
| Export to Access from Excel | Excel Discussion (Misc queries) | |||
| export access to excel. change access & update excel at same time | Excel Discussion (Misc queries) | |||
| Export from Access to Excel | Excel Discussion (Misc queries) | |||
![Shin[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
