While you want Access database referring to your important
excel file, the introduction about importing external data into Access 2013 App
or desktop database in this passage would tell you how to do. So whether you
have such a problem, go on to read.
- S1: Import external file into an Access 2013 app
- S2: Import external data into Access 2013 desktop database
S1: Import external file into an Access 2013 app
Available external file type: Excel workbooks, ODBC data sources,
text/CSV files, SharePoint lists, and other Access databases.
Preparation: Access 2013 has been installed and opened on your computer
and imported files have been prepared on computer or connected storage devices.
Step 1: On the Add
Tables page, you can import data from Excel workbooks, ODBC data resources,
text/CSV files, SharePoint lists, and other Access databases.
Tips: You can see Add Tables page when creating a new custom
app. But if you have already started an app, open it in Access, then click Home - Table.
Step 2: Near the bottom of the Add Tables page, click the
type of data source you want to import, and follow the instructions in the Get External Data wizard.
Tips: Imported data is always added to new table with
default List and Datasheet views.
S2: Import external data into Access 2013 desktop database
Imported data can be added to existing table. And sometimes,
when you couldn’t import data directly into an app, you might be able to import
it into a desktop database first, and then import desktop database table into
the app.
For example: import external excel file into Access 2013 desktop database
For example: import external excel file into Access 2013 desktop database
Step 1: Open Access 2013. On the External Data tab, in the Import
& Link group, click the file type you want to import.
Step 2: Follow the instructions in the Get External Data Wizard. For example, click "Browse" button next
to "File name" box, to specify the source of the definition of the objects. Now we choose to import Excel file.
Step 3: Follow "Import Spreadsheet Wizard" to do.
 |
| 3-1 Choose Show Worksheet you like and click Next |
 |
| 3-2 Check "First Row Contains Column Headings" and click Next |
 |
| 3-3 Set "Field Name" and "Data Type" |
 |
| 3-4 Set datasheet primary key |
 |
| 3-5 Set a name for imported Excel file in Access and click Finish |
 |
| 3-6 Exit "Import Spreadsheet Wizard" |
 |
| or Save Excel import steps |
Step 4: External Excel file has been successfully imported into Access 2013.
Summary:
The beginning of importing different external data into Access is the
same. But it would be different after you choose the file type you want to import. For example, if you want to import SQL database into Access database, it would be more complex
than importing Excel or access database file into Access.
Related Articles:
Related Articles:
No comments:
Post a Comment