|
||||||
|
Import Excel By Richard Rost 3 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? MembersMembers 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 files from class plus get access to the Code Vault. If you're not a member, Join Today!
Links
Keywordsmicrosoft 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
|
||||||||||||||||
| |||
Keywords: TechHelp Access 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, 2gb 2 gb PermaLink Import Excel Data in Microsoft Access |