Thread: export data from Excel to MS Access (ADO) using VBA
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Peter Brom Peter Brom is offline
external usenet poster
  
Posts: 1
Default 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




Reply With QuoteReply With Quote