Access Database Homepage

Question: Is there any easy way of entering data to access database?

(Posted by: Ab Ha on 2010-06-07 03:41:19)

I have a access database. And I have entre some data to the database. But now I have a big list which is in excel sheet. So is there any easy way to entre all the data at ones. Or what are the options i have?

Posted by: iDesign71 on 2010-06-07, 06:49:28

You can import the data. Make sure your Excel list is cleaned up as much as possible, ie no empty rows etc. In your Access database click on the Exernal Data tab and then on Excel in the Import section. Browse to and select your Excel file and select what import option you'd like to use. Follow the prompts to select the import settings and your data will be imported.

Posted by: abhishek on 2010-06-07, 03:56:56

You need to have the knowledge SQL it is database language n u can go to w3schools.com to know further.

Posted by: Brian on 2010-06-07, 04:22:31

Http:/ / office.microsoft.com/ en-us/ excel/ HP052008521033.aspx

Posted by: Simon Belmont on 2010-06-07, 18:33:54

You have lots of options (link, import, etc) but the easiest way is check if table and spreadsheet have the same layout, i.e., the same data fields for data, numbers, strings, etc. After check that information, you can copy all rows (except the header) and copy it on access, inside the table.