|
||||||
|
Import Multiline Cells By Richard Rost 3 years ago Import Data from Excel with Multiline Cells In this video, I will show you how to import data into Microsoft Access from Excel that contains multiline data (cells with line breaks in them). Dean from Gaylord, Michigan (a Platinum Member) asks: we've been storing our membership info in Excel for years. With your videos, I finally feel confident enough to bring this all into Access. Problem is, one of my sheets has the primary member's info (name, address, phone, etc.) and all of his family members are listed in a single cell with line breaks (ALT-ENTER). When I bring that into Access, the names are all smashed together. Is there any way to fix this? MembersMembers will learn how to take those multi-line cells and actually create separate related records in a different table for each of the items in that cell.
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, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, import, excel, line breaks, alt-enter, How to import from Excel and keep the line breaks, Import with line breaks in Access, How to import from Excel and keep the line breaks, import multiline text from excel, excel multiple lines in one cell to multiple rows, chr(13), chr(10), vbNewLine, CR/LF
|
||||
| |||
Keywords: TechHelp Access import, excel, line breaks, alt-enter, How to import from Excel and keep the line breaks, Import with line breaks in Access, How to import from Excel and keep the line breaks, import multiline text from excel, excel multiple lines in one c PermaLink Import Multiline Cells in Microsoft Access |