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

access

ResolvedVersion Standard

Mohammed has attended:
Access Intermediate course
Access Advanced course
Access VBA course

Access

How do you link an Excel spreadsheet with an Access Database? an make a specific sheet selection within an excel link to an access database?

RE: Access

Hi Mohammed, Thank you for your post, An Excel spreadsheet can be linked to an Access Database, follow these steps: in Access choose the menu option File>Get External Data, select Link Tables, in the browse dialog box that opens change file type to Excel and locate your chosen workbook, the worksheets in that workbook will be displayed for selection, choose the worksheet to be linked. (Ensure that the worksheet is compatible with Access requirements, ie field headers etc). Click OK and the Excel worksheet will be displayed in your Table Objects. I hope that helped, best regards Pete.

Access tip:

Hide Access Tables

One method of stopping your Access tables appearing in Database window, is to rename the table(s) with the prefix usys.

This converts the table into a system object, which cannot be viewed in the Database window.

You can show system objects in the Database window by the following:

Step 1: On the Tools menu, click Options.
Step 2: Click the View tab.
Under Show, select the System Objects check box.
Click OK.

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.09 secs.