Mon 27 Apr 2009, 15:49Delegate Andrea said...
Andrea has attended:
Access Introduction course
Access 2007
When appending a table from Excel, will the header of Excel reappear in Access (i.e. showing header line twice)?
Mon 27 Apr 2009, 17:55Trainer Carlos said...
RE: Access 2007
Hi Andrea
The answer is NO.
When you use the append instruction in Access the application uses the Field names/Column headers as labels to the information contained there and therefore doesn't import them as data.
Hope this helps
Carlos
