access

Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

Forum home » Delegate support and help forum » Microsoft Access Training and help » Access 2007

Access 2007

resolvedResolved · Low Priority · Version 2007

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)?

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

Sun 3 May 2009: Automatically marked as resolved.


 

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips


Server loaded in 0.07 secs.