Create a linked table from excel using VBA

[stigmatized]

Hello everyone. I am new in doing the VBA in access and here is my problem.

I have 10 different sheets in a workbook and I want to make link the two sheets to my database which are sheet 1 and 10. In linking the sheet 1 i am using this code:

DoCmd.TransferSpreadsheet acLink, , "Sheet1", "Workbook1", True

i have noticed that this code, by default, is getting the first sheet of the workbook.

Is there any way to put the Sheet name to be linked? My problem is how to link the Sheet 10 using vba.

Hope that you can help me on this.

Thanks.

stigmatized

[ssanfu]

Maybe this will help:
http://support.microsoft.com/kb/173748

[stigmatized]

thanks ssanfu.

is it possible to put a specific range in the excel sheet to be linked e.g. "A6:AA10000" only. My objective is to get the heading to be my fields and it will help me to standardize the fields to be appended in my table.