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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

ASK Field Formatting 1
Blank Page After Envelope-Label Wizard 5
Trying to create custom labels from an csv file + Need items numerically counted out 0
Mail merge labels 8 per page, but 84 is not divisible by 8 3
Duplicate Mail Merge Record Every Time 5
Mail Merge Directory Conditional Page Break 0
Display weeks from a Milestone 0
Visio 2010 - Organization Chart Wizard - Hebrew Excel Database 0

Top