Importing Certain Excel Cells . . . What to do?

[whoneeds8]

I want to import only the information from an excel sheet like the one below where the answers for Q1 and Q2 are No and Yes respectively.

I'm using this code below that is working but importing all cells:

Private Sub Command31_Click()

DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel9, "CustomerRecords", "C:\Documents and Settings\mstafford\Desktop\CustomerRecords.xls", True, "C1:I20"

End Sub

What do I need to add?

 

[Pat Hartman]

If you are asking how to import only rows 2, 5, 7 - you can't - unless you want to write code to automate excel. Import the whole sheet and then use a query to select just the rows you are interested in.

 

[whoneeds8]

If you are asking how to import only rows 2, 5, 7 - you can't - unless you want to write code to automate excel. Import the whole sheet and then use a query to select just the rows you are interested in.

Duh, I'm an idiot. LOL . . . Thanks.

 

[sportsguy]

attach the Excel file as a lnked table,
then write an append query to append only the
records that you want. . .

sounds so simple, and it really is

sportsguy