How to import Excel to Access using VBA

[March]

Dear All,

I would like import data from Excel to Access using VBA. The data in my
Excel sheet is below:

Date A B C
6/24/2008 20 50 55
6/25/2008 25 59 60

In Access, I have one table called “TB1â€
This table has 3 fields
1. date
2. fieldA
3. filedB

Data from Excel will import into “TB1â€

Date filedA fieldB
6/24/2008 A 20
6/24/2008 B 50
6/24/2008 C 55
6/25/2008 A 25
6/25/2008 B 59
6/25/2008 C 60

Are there any ways easy to work with this one?

Please give me suggestion.

March

 

[Arvin Meyer [MVP]]

Access MVP AD Tejpal has this example:

http://www.rogersaccesslibrary.com/ADTejpal/ExcelToAccess.zip

and you might want to also look at Access/Excel automation:

http://www.mvps.org/access/modules/mdl0006.htm

 

[March]

Great sources for VBA.

I may come back to ask you more question tomorrow.

Thank you ,

March