importing part of the excel file into access

[ds_8805]

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

 

[georgedwilkinson]

You can filter a query on a table (linked or not). You really shouldn't attempt to filter a table (linked or not) but you can. I can say from experience that it will give you bad results if you have other users.

 

[ds_8805]

Hey thanks for replying.. filter using a query? cos u see the excel data that I am importing does not really have column headings in the first row.
it looks smthg like this

xx xx xx xx
xx xx xx xx
columnheading 1 columnheading2 columnheading3 columnheading4
data data data data
(where xx represents some data)

so when I import the data to a linked table, it does not have the correct column heading. Then how to write a query to filter so that I get only like the columnheadings and the data after that into my linked table?
Hope I am clear. Thanks

 

[Jasmin]

waiting for an answer too..

 

[DCrake]

If the chunk of data that you are wanting to view in Access is not starting at A1 then what you can do is to use Named Ranges.

Highlight the block of cells in Excel that you want to link Say D5:W200 Then click on the white box above A1 and type in a name then press return.

Save the workbook, Open Access and get external data from Excel you can then specify the named range to link to. Choose the predefined name set earlier.