TransferSpreadsheet

[DZ]

Hi

How can I import a specific worksheet to a specific table. Where the sheet
and table have different names. It seems from the help files, you can only do
this if they are named the sames

Excel Sheet = "SummarySheet"
Access Table = "Summaries"

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
"Summaries", strFullPathOfExcelFile, True

Thanks for any help.
I'll give credt to helpful responses

 

[pietlinden]

Hi

How can I import a specific worksheet to a specific table. Where the sheet
and table have different names. It seems from the help files, you can only do
this if they are named the sames

Excel Sheet = "SummarySheet"
Access Table = "Summaries"

DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8,
"Summaries", strFullPathOfExcelFile, True

Thanks for any help.
I'll give credt to helpful responses

how about this...

http://www.mvps.org/access/general/gen0008.htm