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

Solutions Through Learning

Excellent

Request Callback We will call you back

0207 987 3777 Call for assistance

Your Basket Basket is empty

Forum home » Delegate support and help forum » Microsoft Access Training and help » MS Access/Excel

MS Access/Excel

ResolvedVersion 2003

Tue 18 May 2010, 16:05 Delegate Hannah said...

Hannah has attended:
Access Intermediate course
Excel Intermediate course
Access Advanced course

MS Access/Excel

If i have a list in excel and a MS access database, both of which i know contain some of the same items and i want to know which ones, how can i do this?

Fri 21 May 2010, 14:22 Trainer Stephen said...

RE: MS Access/Excel

Hi Hannah

Thanks for your question.

Can you clarify the following for me please? Does the data in the Access table have the same structure as that in the excel spreadsheet? That is, does it have the same field names (column headings)?

Thanks

Stephen

Access tip:

Insert The Current Time

To insert the current time into a Table field or Form textbox use:

Ctrl+Colon(:)

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

MS Access/Excel

MS Access/Excel

RE: MS Access/Excel

Access articles

Access tip:

Insert The Current Time