Importing Field Labels

P

Penn

Hi,

I would also like to import my field labels with my Excel spreadsheet. How
do I go about this?

Thanks,
SH
 
C

Clifford Bass via AccessMonster.com

Hi,

Specify True for the HasFieldNames parameter:

DoCmd.TransferSpreadsheet acImport, _
acSpreadsheetTypeExcel9, "tblDestination", _
"TheSpreadsheet.xls", True

If that does not help, please be more specific about what you are doing
and why it is not importing the labels. Also indicate what version of Access.


Clifford Bass
 
Top