Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
export data from Excel to MS Access (ADO) using VBA
I'm looking for an example VBA Code to transfer data from Excel to MS Access
2000. The issue is that the spreadsheet contains more then 100 hundred named cells which needs to be transferred to the corresponding Field Name in MS Access 2000. I'm not a beginner programmer but i don't want to code all the separate named cells into MS Access so i'm looking for some smart code to do this. Does anyone know wehere i can find some example VBA code to accomplish this. Thank you in advance Peter Brom |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Export from Access to Excel | Excel Discussion (Misc queries) | |||
How can I Export data from to Access to an Excel Template | Excel Discussion (Misc queries) | |||
Export memo field in Access to Excel - data gets cut off | Excel Discussion (Misc queries) | |||
Export Excel Data to Access With a Macro!!! | Excel Discussion (Misc queries) | |||
Export Excel data to Access Security problem | Excel Programming |