how can I read certains cells from Excel in Access

[diaExcel]

I have a part of the workbook in Excel:

A B C

AFGHANISTAN Herat 93 40
AFGHANISTAN Jalalabad 93 60
AFGHANISTAN Kabul 93 20
AFGHANISTAN Kandahar 93 30
AFGHANISTAN Mazar E Sharif 93 50

and I want to save all the data in a table in Access, how can I do that?

Thank you.

 

[Alex Dybenko]

Hi,
if you need to get data from this workbook on regular basis - you can use
Docmd.Transferspreadsheet method

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[diaExcel]

Hi,

actually I use Access 2003, and I want to use through a form (use an object).
Thank you

"Alex Dybenko" a scris:

 

[Alex Dybenko]

Then look at this post, it show how to get/set data in excel sheet as object
http://accessblog.net/2005/09/how-to-modify-embedded-ms-office.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com