By Richard Rost 3 months ago
Importing Text into a Microsoft Access Table
In this Microsoft Access tutorial, I'm going to teach you how to import data from a text file into your database. We will use the file that we exported in yesterday's video. For the advanced VBA users, I'll demonstrate how to accomplish this with a single-click solution. We will also work with a delete query and an append query, and include a 'Are you sure?' message box for user confirmation.
Members will once again see how to use TransferText to import the data with more advanced options in VBA.
Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the database template from class plus get access to the Code Vault. If you signed up on YouTube you have to register on my YouTube Find User page so I can set up your account here on my web site. If you're not a member, Join Today!
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, Import Text, TransferText, run-time error 3127, the insert into statement contains the following unknown field
Subscribe to Import Text
Get notifications when this page is updated