Convert Microsoft Excel to Microsoft Access

Convert Microsoft Excel to Microsoft Access

First you need to remove any data that you don't need from your worksheet by selecting the area, then right click your mouse and press cut/delete.

.

Open a new access workpage,

 

Select file and go to external data, import then switch the file type to excel(xml file) and then choose the worksheet to import.

Automatically access will create a Primary Key , this helps when combining the rows and columns.

 

Another way to do it is:

Highlight the area of the worksheet in excel you want to change to access, then right click your mouse and select copy.

Go to Access and form a new work area then right click your mouse and press Paste.

Convert Microsoft Excel to Microsoft Access

Mr Paolitaviena, this is a very simple problem to solve and it is good you asked it since I will give you a step by step solution on which you should never have a problem.

• You need first to open the Ms Excel and where the worksheet is. This you will do by going to Start->All Programs > Microsoft Office > Ms Excel
• Once you open excel and the worksheet with the data,go to Ms Access and open.
• Open Ms Access and create a new blank database where you will transfer the work.
• Ensure you have your data organized in a consistent manner in rows of cells so that results for each potential field line up in database line under each other in the spreadsheet.
• Rows of data should have a heading at the top. Follow good naming conventions
• Once you have data setup, set a database range that covers all fields and all rows that you want to import for particular collection of data.

• You may then import manually as shown in the diagram,but the method doesn't always usually work. Another method, is that you have to transpose the cells;
• Select the cells you want to transpose.
• Click Ctrl+C to copy
• Select the upper left cell of paste area. Paste area must be outside of copy area
• On edit menu click Paste Special
• Select transpose check box
• Use import command button from file menu in access.
• Use linked tables. Access can link to a name range in a spreadsheet and will allow you to manipulate the data as if it were a table.

You need to use the transfer spreadsheet method in Visual basic or in macros.

This should be able to convert the files.

Hope this helps.

Convert Microsoft Excel to Microsoft Access

Hi,

Friends I am telling you some easy setups to convert Microsoft Excel 2007 Data in Microsoft Access without losing your Excel Data. Please follow these steps:

1. Open Your Microsoft Access 2007 Database Document 
 

 

2. Click on blank database folder 
 

      
 

3. Choose Blank database file name and click on create option and create blank database file.  
 

 

4. Go to access menu bar and click on External Data menu option.
 

 

5. After, select and click Excel menu option. 
 

 

6. See This Dialog Box and click on file Browse Option.
 

 

7. Browse your Excel Data file you want to convert in access data.

 

 

8. See and check your browser name and click on ok button.
 

 

9. See and select your Excel worksheet name and click on Next button
 

 

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.

 

 

Thanks.

Vksdone