Subscriber only lesson.
Sign up to this course to view this lesson.
Import objects from Access, Trust Center
ASCII stands for American Standard Code for Information Interchange, and is a character-encoding scheme where each letter, number, and special character is assigned a unique number. Capital A is 65. ASCII is based on the English alphabet, uses 7 bits, and limited to 128 characters. Extended ASCII can encode 256 characters.
A BCDM File is a business data connectivity metadata store file in XML format that contains definition information for connecting to a data service. Flat data structures are the only supported types – at this point, hierarchical data structures are not.
A CSV file is stored in plain text and stands for Comma-Separated Values. When Excel is installed, it is chosen to be the default application for opening CSV files. If you have long numbers in a CSV file, they may be converted to floating point by Excel, rendering them useless if they are key fields for matching data. If you open a CSV file with Excel, don't save it unless you ensure all the data is good.
You can link to an existing data service, or create your own. The connection will be read-only and you can Refresh to update the information.
DNS stands for Data Name Source. A DNS file is a text files specifying DRIVER, UID, PWD, DATABASE, and SERVER and can be used to connect to data in a variety of formats. For information on how to use a DNS file, watch the following presentation starting from 0:35:11
Microsoft MVP Virtual Conference 2015 -- Access Web Apps, linking to SQL Azure from Access desktop, Excel workbook, and SSMS (53 minutes)
The data for many Access databases comes from Excel, which is the Microsoft Office spreadsheet application. Data can be import from, and exported to, Excel.
Access can convert data to a variety of formats. This is the Export group on the EXTERNAL DATA tab.
The External Data ribbon enables you to import and link to data stored in other applications. You can also export data stored in Access to other formats.
When importing information from an HTML file into Access, the HTML file must be structured with cross-origin resource sharing (CORS).
Importing is bringing data and objects into your database from another file. Access supports a variety of formats.
Share data stored in another file. When you link, the data can be refreshed when it changes, giving you the ability to see the latest information.
ODBC is Open DataBase Connectivity. Many database management systems have ODBC drivers that enable Access to get and share data. ODBC is an interface written in C and was developed by Microsoft in 1992. Some ODBC-compliant databases, and applications that have bridges to ODBC include:
- FileMaker Pro
- Microsoft Excel
- Microsoft SQL Server
- Visual FoxPro
For more information on ODBC, refer to:
ODBC Programmer's Reference
When you import from an ODBC database, you can specify a DNS file on the File Data Source tab
… or specify each of the choices using the New… command button on the Machine Data Source tab, then picking the source, clicking OK, then filling out necessary information in the wizard.
Access can import and link to mailboxes and address books in Outlook.
An important strength of Access is how easy it is to import and share data with other applications … after all, this is how Access got its name! Access is a landing pad for all types of information. Look on the EXTERNAL DATA ribbon in the Import & Link group to bring data in, and in the EXPORT group to shuffle data out.
SharePoint is a web application platform. SharePoint is needed to develop and run Access (Web) Apps and is included in Office 365 packages.
A SharePoint List is a container for data that can be accessed using a web browser hosted on a SharePoint site.
A text file is composed of ordinary characters and is readable by most applications. Text files can be ASCII files and/or Unicode files.
Trust Center Settings
The Trust Center, accessible from File, Options, give you the ability to choose Trusted Locations, Trusted Document, Trusted Publishers, Add-ins, ActiveX Settings, Macro Settings, Message Bar, and Privacy Options.
Unicode, like ASCII, is a way of encoding characters. Unicode supports more characters than ASCII and takes more space to store. UTF-8 is the official Unicode specification, uses one to four 8-bit bytes, and results in 1,112,064 combinations. If it is desired to store Unicode characters, the Unicode Compression property of fields must be set to Yes.
Word is the Microsoft Office word processing application. Data can be exported to Word from Access.
XML is an eXtensible Markup File. It is a text file (plain text or Unicode) that is structured using angle brackets <definition> to provide a schema. Access cannot natively read hierarchical XML files.
Import from Access
- Click on the External Data ribbon
- Choose Access from the Import & Link group
- Browse to the database you want to import from
- When the wizard comes up, pick the objects that you want
- If you imported Modules, be sure to go to VBA and Debug, Compile
- From the menu, choose File, Options, Trust Center
- Click the Trust Center Settings... button
- Choose Trusted Locations
- Check the box to "Allow Trusted Locations on my network" if you are on a LAN
- Click the Add new location... button
- Enter the drive you want to trust
- and check "Subfolders of this location are also trusted"
- Click OK on each menu to accept the changes.
Lesson notes are only available for subscribers.