Reading excel spreadsheet

[mls via AccessMonster.com]

How can I extract the excel spread sheet data, cell by cell and append it to
your Access table when some one types the xls file name in the form input.
I.e I am creating a form where it takes file name, date as input paramaetes
and read that excel cells ( 1st , 2nd 5 th and 19th row and create an ACCESS
table. ( my xls file name changes but the cells I need to read remain
constant.

I want to do this using VBA coding? Any one have any idea to do this? or do
you have any links that I can refer to?

Thanks in advance.

 

[Ken Snell]

Perhaps this article will be a good starting point for you:

Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst

 

[mls via AccessMonster.com]

Thank you very much I will look in detail. I googled a lot and could not find
this type of detail document in my search.

Currently my project is based on reading from and writing to excel template,
after processing some business rules in ACCESS and this helps a lot

Perhaps this article will be a good starting point for you:

Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst

How can I extract the excel spread sheet data, cell by cell and append it
to

[quoted text clipped - 11 lines]

Thanks in advance.