01. Intro to File I/O (18:32)
Why learn File I/O
Types of File I/O: Classic VB & FSO
Pros & Cons of Each
02. TechHelp 1: Import Data (13:12)
Import CSV Files into Access
03. TechHelp 2: Import w File I/O (24:04)
Import Fixed Width Text File
File Sizes Greater Than 2 GB
04. Classic VB File I/O, Part 1 (42:07)
Write a Text File
Open Filename For Output as #1
Print, Close, Append
What Folders you can Write to
CurrentProject.Path
FreeFile #FF
Shell Notepad to View File
Create Customer Summary to Email
Loop Thru All Text Boxes on Form
Dim Ctl As Control
For Each Ctl in Me.Controls
ControlType acTextBox
Exclude Fields for Export
Use Recordset to Print Multiple Records
Export an Invoice
05. Classic VB File I/O, Part 2 (43:12)
Reading Text Files
Open Filename for Input as #FF
Reading in Lines of Text
Line Input
Read to End of File (While Not EOF)
Reading in Customer Data File
Emailing Surveys
Copy Paste Responses and Read Into Table