Convert Microsoft Excel to Microsoft Access

To convert your existing worksheet of Excel to Access 2007, follow the steps given below:

1. Create a new Blank Database in Microsoft Access

2. Access will by default open a new blank table. Just Close that Table and do not save it.

3. Now On the Access Ribbon Click on the "External Data" Tab.

4. Click on Excel in Import Category

5. The above will open up a wizard that will import data from Excel. You Just go through the process.

6. Use the Browse Button to Specify Path to the Excel File.

7. Click on the Radio Button below to specify in which database you want the data to be imported. For the database created click on Import the source data into a new table in the current database and Click on OK button to continue.

8. Now Select the name of Worksheet You want to import. and Click Next

9. Now on the next screen put a check that your first row in excel sheet contains the field names, If your sheet don't have field names then remain it uncheck. it will assign default names to fields, and you can change them later. Press the Next Button

10. Now is the time to assign data types to fields, select the field and put the type of data that is inserted in that field. After assigning a data type to all fields press Next

11. Now assign a field as a primary key if you want to, The field that contains Unique contents and Press Next

12. Now give the Table Name in the text box and press finish.

13. Now if you have Multiple sheets and have same process, save the steps you have done by checking the check box and this will save your time in future.

10. Click on [ / ] first row contains column heading box and after click on Next button.

11. Here you can change you file name if you don’t want change your file click on Next button.

12. Your next Setup is that you can change your file row and columns style by selecting any primary key. If you want to change it you can click on any key. if you don't want any style please click on next button.

13. It is your final setup click on finish button on this dialog box.

14. Your Data has been converted in Excel to Access. click on the right side sheet 1

15. And you can see Your Excel 2007 Data has been converted in Access 2007.

Techyv is one of the leading solution providers covering different aspects of Computers and Information Technology. We have a hardworking team of professionals in different areas that can provide you with guaranteed solutions to a blend of your problems. We have a dedicated and devoted team of professional writers with multi-dimensional experience of several years. As a result, we produce quality content on a variety of subjects.