+ Reply to Thread
Results 1 to 2 of 2

Text File import to Access tables

  1. #1
    Registered User
    Join Date
    01-08-2012
    Location
    Dubai
    MS-Off Ver
    Excel 2007
    Posts
    71

    Text File import to Access tables

    Hi All
    I have a text file which has records in a multi line structure.
    Each record is separated with a blank line in between.
    Some records will have 9 fields (in text file it is 9 lines)
    and some of them will have 12 fields (or 12 lines in the text file). If the line has only "Layers" in the start line that line and the next following lines to Tbl1 and if the line has "Groups" in the middle of the line it should be saved in the Tbl2.
    There are lines end with "*" symbol should not imported to any of the tables.There could be one Layer record then several group lines then again layer then groups like that.
    I am trying to import this data to an access table. Hope some of the experts can help me to resolve this. I am attaching 2 sample files. One is a txt file and another one an Excel file which shows the expected result.
    Please help
    Attached Files Attached Files

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Text File import to Access tables

    Data in Access needs to be in a normalized fashion. You will need to normalize your data before you bring it into Access. To better understand this, read this white paper on data base design.

    http://r937.com/relational.html
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Import Text File to Access Table using Excel VBA
    By balajismith1992 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-28-2015, 09:34 PM
  2. Use an Excel Macro in Access VBA - Import text file in Access Table
    By joogibabu in forum Access Tables & Databases
    Replies: 3
    Last Post: 10-08-2014, 10:04 AM
  3. text file upload in Access tables using VBA
    By irfanparbatani in forum Access Tables & Databases
    Replies: 3
    Last Post: 05-13-2014, 08:19 PM
  4. Text File Convesion to Access Import
    By JerryCapo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-02-2014, 10:07 AM
  5. Import Text File to Access Table using Excel VBA
    By curiosity1990 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 05-07-2013, 09:43 AM
  6. import tables in to access from another access database
    By jsimha in forum Access Tables & Databases
    Replies: 1
    Last Post: 12-16-2010, 05:31 PM
  7. Import Multiple Tables From Access
    By tommyfernandez in forum Excel General
    Replies: 2
    Last Post: 12-10-2008, 04:43 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1