Brothersoft.comWindows|Mac|Mobile|Games

|Message

Solve software problem quickly Share experience to help others Improve the ability of solving problem
how to create a Database from an Excel Spreadsheet?

12/06/2011 02:48 by ThomasOakes

First answer posted by Kimplex at 12/06/2011 02:48
Add Your Answer
10~1000 characters in length CAPTCHA:
1 Answers
  • Kimplex
  • In Microsoft Access
    1. Create a spreadsheet in excel. Save the spreadsheet to a location on your hard drive.
    2. Launch Microsoft Access. Open an existing Microsoft Access database or create a new, blank database.
      • Microsoft Access is designed for use with Microsoft Excel and comes bundled with Excel in Microsoft Office Professional.
      • You can also purchase Access alone to discover how to create a database from an Excel spreadsheet
    3. Click the "External Data" tab and select the "Excel" icon on the ribbon
    4. Click the "Browse" button to navigate to the location of the Excel spreadsheet.
      • Alternatively, you can type the file path into the field, for example: c:/users/<username>/documents/addresses.xls (or addresses.xlsx)
    5. Specify how you would like the information to transfer to the database by selecting one of the following options:
      • Import the source data into a new table in the current database: Use this option if you are using a brand new database with no tables or if you want to add a new table to an existing database. By creating a new table you can edit the information in Access.
      • Append a copy of the records to the table: Use this option if you are using an existing database and want to add the data to one of the tables in the database. By appending an existing table, you can edit the information in Access.
      • Link to the data source by creating a linked table: Use this option to create a hyperlink in the database, which will open the excel database in excel. With this method, you cannot edit the information in Access.
      • Click OK after you have selected your transfer method.
    6. Select the sheet you want to import from the list.
      • By default, Excel creates workbooks with three spreadsheets labeled "Sheet 1," "Sheet 2," and "Sheet 3." You can delete, add and edit the names of these sheets in Excel, and whatever changes you make will show up in Access.
      • You can only transfer one sheet at a time. If you have information on all three sheets, you must complete the transfer with one sheet then go back to the "External Data" tab and repeat all the steps for each remaining sheet.
      • Click "Next" after you have selected the spreadsheet.
    7. Leave the checkmark in "First Row Contains Column Headings," if that is the case. If not, remove the checkmark and Access will create its own column headings. Click "Next."
    8. Edit the field type, if desired, or indicate if you wish to import the field.
      • If you are importing all the fields from the spreadsheet, as-is, do not make any changes at this screen and click "Next."
      • If you wish to change the nature of one of the fields, click on the column header you wish to change and edit the name of the field, the data type, or whether or not it is indexed. Then click "Next."
      • If you want to skip that field, put a check mark next to "Do Not Import Field (Skip)," then click "Next."
    9. Set the primary key for the database. For the best results, let Access set the key. You can also set your own by typing text into the field next to that option, or you can select "No primary key" which is not recommended. Click "Next."
    10. Type the name of the sheet in the "Import to Table" field, or leave it set to the default name.
      • Click "Finish" and put a checkmark in "Save These Import Steps" to use the same steps on future imports.
      • Click "Close" to create your database.
  • Was this answer helpful? 00 · 12/06/2011 02:48
Add Your Answer
10~1000 characters in length CAPTCHA:
Related Questions
Q:What do you think of Microsoft Excel Viewer?

A:Good job, helped me a lot.

Q:Print more than one page?

A:Set on your Printer Setting. When you click Print, your Printer will pop up. Tthere is a button for you to choose which to print. Click on "Pa...(more)

Q:edit excel spreadsheet in autocad file using openoffice.org

A:Not sure whether this will help, but give it a try: Right-click the dwg file, select "Open With" and then "Choose Default Program." choose op...(more)

Q:MICROSOFT EXCEL 2003: PROBLEM - I NEED TO SUM A RANGE OF DATA - EXPENSES, BASED ON TWO CRITERIAS. THE 1ST CRITERIA IS A RANGE OF DATA THAT = CBC0600 (CBC0600 IS JUST ONE EXAMPLE)

A:Here is instruction about how to SUM cells based on multiple criteria by using DSUM: Adds the numbers in a column of a list, or database, tha...(more)

Q:EXCEL 2003: PROBLEM - I NEED TO SUM A RANGE OF DATA - EXPENSES, BASED ON TWO CRITERIAS. THE 1ST CRITERIA, COLUMN B, IS A RANGE OF DATA THAT IS ALPHA NUMERIC.

A:Here is instruction about how to SUM cells based on multiple criteria by using DSUM: Adds the numbers in a column of a list, or database, tha...(more)

0 people are following

Ask a question now
Write a title for your question

Microsoft Excel Viewer 2003

open, view, and print Excel workbooks, even if you have example excel formula.
Latest version:1.0
License:Freeware
OS:Windows 2003,Windows XP,Windows 2000
Total downloads:445,228
Rank:1 in Spreadsheets
Download It

Share with friends

New features is coming

  • 1. Providing high-quality answers to be a verified Q&A expert
  • 2. Ask and answer questions to get Brothersoft credits

Added Successfully!

×

Are you sure to delete your answer?

NoYes

×

Are you sure to choose it as the best answer?

NoYes

×

Voted Successfully!

×

You can't vote for yourself

×

You can't choose your own answer

×