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 ...
BECOME A MEMBER:
KZbin: / @599cd
or My Site: 599cd.com/THMe...
LEARN MORE:
599cd.com/Impo...
LINKS:
Import New, Changed Records: 599cd.com/Impo...
Importing in Access Expert 20: 599cd.com/ACX20
Left Right Mid Functions Expert 14: 599cd.com/ACX14
Recordsets Tip: 599cd.com/Reco...
Recordsets Access Developer 16: 599cd.com/ACD16
File I/O: Coming Soon to a Developer Class!
COURSES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Cont...
Order Entry & Invoicing: 599cd.com/Invo...
More Access Templates: 599cd.com/Acce...
ADDITIONAL RESOURCES:
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/Tech...
Paid TechHelp Questions: 599cd.com/Tech...
Consulting Help: 599cd.com/Cons...
Twitter: / learningaccess
en.wikipedia.o...
products.offic...
microsoft.com/...
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.