Results 1 to 5 of 5
  1. #1
    kevinh2320 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2017
    Posts
    3

    text file import question.

    I am importing a text file. The text file only has one field called Request. Does anyone know a way that I can take this data and create a table with fields for each line.

    This is how the file import comes in:
    Request
    *Report Request: 9557*
    Date Submitted: Feb 1, 2017
    Date Updated:
    Date Needed: May 31, 2017
    Technican:
    Date Checked Out:
    User Name: jsmith
    Email: jsmith@abcde.com
    Phone: (555)123-4567


    Division: Northen Division
    Work Unit: Leasing
    Also Send report to:
    File: 64576
    Project Name: POINT COM DEVELOPMENT SITE
    Report Scope: Full Report
    Report Type: General
    Concerns: Full Report for Point com development site lease

    I want to convert it into a format like this:

    ReportNum DateUpdated DateNeeded Technician DateCheckedOut UserName
    4315 5/25/2017 5/31/2017 jsmith jsmith

    Any help greatly appreciated.

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    this is horrible way to save data.
    youd need a vb program to go line by line and extract the data , and post it into fields.

  3. #3
    kevinh2320 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2017
    Posts
    3
    Couldn't agree more. But, it's what I have to work with and it's driving me crazy!

  4. #4
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Working with bad data layouts can be difficult.
    If it was me, I would probably create an Excel macro to extract what you need and put it in a format more conducive to import into Access.

  5. #5
    kevinh2320 is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    May 2017
    Posts
    3
    Yep. Good suggestion. Think that's what I'm going to have to do. Thx.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. VBA To Import Text File
    By jo15765 in forum Macros
    Replies: 7
    Last Post: 04-21-2016, 06:28 PM
  2. import text file with text date
    By rody in forum Import/Export Data
    Replies: 5
    Last Post: 09-01-2014, 12:50 AM
  3. Import Text File
    By vvasudev in forum Import/Export Data
    Replies: 1
    Last Post: 02-17-2012, 01:57 AM
  4. Question on Macro to automate file import
    By delkath in forum Access
    Replies: 4
    Last Post: 05-25-2010, 04:28 AM
  5. Import text file question
    By sumdumgai in forum Import/Export Data
    Replies: 14
    Last Post: 03-23-2010, 07:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums