Access 2007

Resolved · Low Priority · Version 2007

Mon 27 Apr 2009, 15:49 Delegate 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:55 Trainer 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

Sun 3 May 2009: Automatically marked as resolved.

Training courses

	98.8 % recommend us
	More live stats...

Training information:

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