{"id":1760,"date":"2013-06-16T05:50:34","date_gmt":"2013-06-15T19:50:34","guid":{"rendered":"http:\/\/www.rjmprogramming.com.au\/wordpress\/?p=1760"},"modified":"2018-02-01T11:36:12","modified_gmt":"2018-02-01T01:36:12","slug":"access-csv-import-primer-tutorial","status":"publish","type":"post","link":"https:\/\/www.rjmprogramming.com.au\/ITblog\/access-csv-import-primer-tutorial\/","title":{"rendered":"Access CSV Import Primer Tutorial"},"content":{"rendered":"
\"Access<\/a>

Access CSV Import Primer Tutorial<\/p><\/div>\n

Welcome to the Access (Database Server) CSV Import Primer Tutorial.<\/p>\n

Microsoft Access, also known as Microsoft Office Access, is a database management system from Microsoft that combines the relational Microsoft Jet Database Engine with a graphical user interface and software-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and higher editions or sold separately.<\/p>\n

Microsoft Access stores data in its own format based on the Access Jet Database Engine. It can also import or link directly to data stored in other applications and databases.[1]<\/p>\n

Software developers and data architects can use Microsoft Access to develop application software, and “power users” can use it to build software applications. Like other Office applications, Access is supported by Visual Basic for Applications, an object-oriented programming language that can reference a variety of objects including DAO (Data Access Objects), ActiveX Data Objects, and many other ActiveX components. Visual objects used in forms and reports expose their methods and properties in the VBA programming environment, and VBA code modules may declare and call Windows operating-system functions.<\/p><\/blockquote>\n

Microsoft Office Access Database Server is an excellent database to use and its integration with other Microsoft Office products makes it a force to be reckoned with, along with its External Import functionality which was used to good effect in this tutorial where CSV data was imported into the Access database.<\/p>\n

The CSV<\/a> data used is from GeoLite Free Downloadable Databases<\/a> for whom I give thanks, because, as we all know, interesting data is INTERESTING!!<\/a><\/p>\n

Doing this tutorial, I was amazed how user friendly it is, and can imagine setting up workable systems in a short space of time. Add to this its support for VBA, SQL queries, Macros and Forms, and you can see its power.<\/p>\n

In this primer tutorial<\/a> you can see the Microsoft Office Access program in use importing CSV data into the database, though there are more recent improved versions of this product available. Want to direct you towards some useful links below.<\/p>\n

Link to Access Database Server more information … via Wikipedia, from where quote above came<\/a>.
\nLink to Access Database Server home … via Microsoft<\/a>.
\nLink to Microsoft Office home … via Microsoft<\/a>.
\nLink to Access Database Server jobs done … Access Database Server jobs done<\/a> … some of personal experience.<\/p>\n

This product includes GeoLite data created by MaxMind, available from
\n http:\/\/www.maxmind.com<\/a>.<\/p>\n

If this was interesting you may be interested in this<\/a> too.<\/p>\n