importing part of excel file into access

[ds]

Hello everyone. I am a newbie in access. I would actually like to import like
only
certain rows and columns from an excel file into a table into access. As the
excel
data would be changed dynamically, I have decided to use a linked table
instead. Is it possible for the linked table just to display the specific
rows and columns i want?

Hope someone can help me! Thanks

 

[Ken Snell]

No. A linked EXCEL spreadsheet shows all the data in the spreadsheet.

You'd need to import the desired data into a local ACCESS table. See this
article for one way to do this:
Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst

 

[ds]

Hey Thanks! I will try this out

No. A linked EXCEL spreadsheet shows all the data in the spreadsheet.

You'd need to import the desired data into a local ACCESS table. See this
article for one way to do this:
Write Data From an EXCEL Worksheet into a Recordset using Automation (VBA)
http://www.accessmvp.com/KDSnell/EXCEL_Import.htm#WriteFileRst

--

Ken Snell
http://www.accessmvp.com/KDSnell/







.