MRdNk

Hi,
My name is bairam, Recently i have started working with VBA, Need some one to help me in the following:

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel9, "dbo.tblimport", filetouse, False ' , "Batch!" & strRowStart & ":" & strCol & strRowEnd

dbo.tblimport is the table name, "Batch!" & strRowStart & ":" & strCol & strRowEnd is my range to be copied

I am not getting any error and the following code execute as usual, but no import is being done.

The excel file which I am using has columns which are done by some formula, but in my range the heading are not being used.

Appriciated
Bairam