By Richard Rost 2 years ago
Import Data from Excel, CSV, Fixed-Width Text
In this video, I will show you how to import data into Microsoft Access. We will see how to import Excel spreadsheets, CSV (Comma Separated Values) files, and fixed-width text files.
John from Coppell, Texas (a Developer Student) asks: I need to import a very large file that I received from a client. It's a fixed-width text file. How can I get that data into Microsoft Access?
Members will learn how to use VBA, recordsets, and file I/O (Input/Output) to directly import a large text file, line by line. This is sometimes necessary for very large fixed-width text files that may be over 2 GB in size.
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!
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, import, import excel to access, csv files, comma delimited files, fixed width files, automate import data from excel to access, open file vba, vba file i/o, input/output, recordset
Subscribe to Import Excel
Get notifications when this page is updated