what's the range to import fifth sheet only (columns A to D)

G

Guest

I used TransferSpreadsheet to import the first sheets from Excel file. Now I
want to do the same thing but this time I want to import only the fifth sheet
with name INCOME of excel file and to import the first 4 columns (A to D).
Using TransferSpreadsheet I know can put the range. Can you tell me how to
write the range for this problem

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "tblTemp",
strFile, True, "........."
Kostas
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Possible to import a specific sheets data from excel into access? 1
Importing Excel Sheet into Access Database using VBA 2
how to import multiple Excel files into multiple Access tables? 9
Import a named range from Excel 2
More the one range with DoCmd.TransferSpreadsheet 1
Dialog Box to Select Import File 4
Importing from excel- range problem 1
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0

Top