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

Access

ResolvedVersion 2003

Thu 9 Oct 2008, 16:08 Delegate Amanda said...

Amanda has attended:
Access Introduction course

Access

Can I export and import data into Access?

Fri 17 Oct 2008, 15:00 Trainer Simon said...

RE: Access

Hi Amanda,

Thank you for your question.

If you have an excel list with data arranged by column headings you can use the Get External data command.

If you open the database and then go to File, Get External Data and choose Import. Change the File Type from Access to Excel and select the Excel file. Then follow the steps of the Import Wizard.

To export the data to Excel or Word, select the table or Query and go to Tools and Office Links and choose the appropriate option.

I hope this answers your question.

Regards

Simon

Training courses

98.7 % recommend us

More live stats...

Training information:

Access tip:

Deleting duplicate records from a table

You cannot delete records tables where there duplicate records. A way around this is to create a new table which wont hold the duplicates. and then deleting the old table.

1. Use a make-table query based on this table only. IMPORTANT - Ensure that you include all of the fields from your original table or you may loose data.

2. Open the query's property sheet by using VIEW, QUERY, PROPERTIES, and set the Unique Values property to Yes

3. Because you have selected the Unique Values to Yes when you run the query, Access creates a new table without duplicate records. You can now delete the old table and rename the new one.

View all Access hints and tips

Access

Access

RE: Access

Access articles

Access tip:

Deleting duplicate records from a table