import Excel to Access

[vicgirl]

Hi,
Does anyone know how to import a certain rows of worksheet in Excel to Access table? For example, I want to import row 1-35 from Excel worksheet to Access.

 

[nigi]

Hi vicgirl.

All you have to do is to create a new table by importing the specific excel sheet you are interested in. Make sure you let access create the primary key for you. After this you create a query that looks like this:

SELECT *
FROM YourTable
WHERE YourTable.ID>0 And YourTable.ID<36;

...where ID is the primary key.

Hope this helps!