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

how do i updatefrom

Forum home » Delegate support and help forum » Microsoft Access Training and help » How do I updatefrom an excel spreadsheet

How do I updatefrom an excel spreadsheet

ResolvedVersion Standard

Frederic has attended:
Access Introduction course
Access Intermediate course
Excel VBA Intro Intermediate course

How do I updatefrom an excel spreadsheet

How do I update a database from an excel spreadsheet without having to open the actual database.
Thank you.

Fred

Edited on Thu 27 Mar 2008, 16:05

RE: How do I updatefrom an excel spreadsheet

Hi Fred,
Welcome to the forum, Thank you for your post, in answer to your question, if you should have created a link between the spreadsheet which holds the variable data and the Access Database by using the File>Get External Data option in Access, and Using the Link Tables option, In the Link dialog box; change the Files of Type to Microsoft Excel, navigate to your chosen Workbook, select the Workseet to use and follow the options in the Link Wizard dialog boxes as required. When you click the final Finish button your worksheet will be imported into Access as a linked table. Any changes in your Excel Spreadsheet will be shown in your Access Database the next time it is opened.
Note: your worksheet should be created as a list with just field headings in row 1, and the data directly beneath, row 2, 3, 4 etc. I hope that has been of help to you, best regards Pete.

Access tip:

How To Find All Overdue Accounts?

To find overdue accounts create a filter that compares today's date with the Invoice Date in the table. To do this:

1. Open the Query in Design View
2. Select the field for the filter and in the criteria row enter:

<Date()

This filter returns records where the Invoice Date is before today's date.

This filter can be manipulated if, for instance, Invoices are due 15 days after the Invoice Date. For this the filter would be:

<Date()-15

This filter returns records where the Invoice Date is 15 days before today's date.

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.11 secs.