Tech Support Guy Forums - Conversation Between MRdNk and bairamsunil

>
Conversation Between MRdNk and bairamsunil

Tip: Click here to scan for System Errors and Optimize PC performance
[ Sponsored Link ]

Conversation Between MRdNk and bairamsunil

IMPORTANT! READ THIS FIRST!
This form is to write a personal message to another user. DO NOT ASK FOR TECH SUPPORT HERE. To ask your tech support question, please go to the forums or read our welcome guide for new members. Thanks for your cooperation!

Showing Visitor Messages 1 to 1 of 1

02-Jun-2008 04:12 AM
bairamsunil

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

Twitter! | Podcast | Mobile | Advertise