Import Data into Microsoft Access from Microsoft Excel, CSV Files, and Fixed-Width Text Files

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?

Silver Members and up get access to an Extended Cut of this video. 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.

MEMBERS VIDEO:
   • Import Data to Access from Excel, CSV...  

BECOME A MEMBER:
YouTube:    / @599cd  
or My Site: https://599cd.com/THMember

LEARN MORE:
https://599cd.com/ImportData

LINKS:
Import New, Changed Records: https://599cd.com/ImportChanges
Importing in Access Expert 20: https://599cd.com/ACX20
Left Right Mid Functions Expert 14: https://599cd.com/ACX14
Recordsets Tip: https://599cd.com/Recordsets
Recordsets Access Developer 16: https://599cd.com/ACD16
File I/O: Coming Soon to a Developer Class!

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Paid TechHelp Questions: https://599cd.com/TechHelpPaid
Consulting Help: https://599cd.com/Consulting
Twitter:   / learningaccess  
https://en.wikipedia.org/wiki/Microso...
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft...

KEYWORDS:
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

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.