Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Excel data to Access
hi all,
I'd like to add a command button "Add" on my worksheet to automatically populate all data (about 50 rows every time) to an Access table "tbl_input" with special condition. Please see example below: data on worksheet starting cell B3, A 20 20 40 20 40 A 40 30 40 30 30 B 30 60 20 30 50 C 100 80 60 80 40 ....... I'd like the VBA code (macro) to populate the data in this way please. for data "A 20 20 40 20 40", I'd like to put "A" in "size" field of "tbl_input" in Access db, "20" in field "A1", the next "20" in field "A2", and so on.... for data "B 30 60 20 30 50", put "B" in "size" field" of "tbl_input" in the same db, the put the rest in field "B1", "B2", "B3", and so on... similarly for data "C 100 80 60 80 40", in "Size", "C1", "C2",.... Thanks in advance for your help! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Add Excel data to Access
Start he
http://www.erlandsendata.no/english/...php?t=envbadac "Huaqin" wrote: hi all, I'd like to add a command button "Add" on my worksheet to automatically populate all data (about 50 rows every time) to an Access table "tbl_input" with special condition. Please see example below: data on worksheet starting cell B3, A 20 20 40 20 40 A 40 30 40 30 30 B 30 60 20 30 50 C 100 80 60 80 40 ...... I'd like the VBA code (macro) to populate the data in this way please. for data "A 20 20 40 20 40", I'd like to put "A" in "size" field of "tbl_input" in Access db, "20" in field "A1", the next "20" in field "A2", and so on.... for data "B 30 60 20 30 50", put "B" in "size" field" of "tbl_input" in the same db, the put the rest in field "B1", "B2", "B3", and so on... similarly for data "C 100 80 60 80 40", in "Size", "C1", "C2",.... Thanks in advance for your help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can Excel access data from Access?! | Excel Discussion (Misc queries) | |||
best way to get data from Access to Excel? | Excel Programming | |||
How do you get data to/from Access DB in Excel VB? | Excel Programming | |||
Access data -work in Excel- save in Access | Excel Programming | |||
Data from Excel to Access | Excel Programming |