Results 1 to 4 of 4
  1. #1
    Join Date
    Mar 2006
    Posts
    2

    CSV File Import


    I have a csv file that contains data, but there are no columns defined and the data is the same place all the time but spread out over many lines.

    Example of row:
    "Purchase Order No.","Customer ID","Salesperson ID","Shipping Method","Payment Terms","Req Ship Date"

    Another row would have bill to name and ship to name
    next row has their address
    next row has city, state and zip.

    Is there a way to input into access using vba.

  2. #2
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    A sample file (or at least a copy-paste of several records from the file) would be helpful...

  3. #3
    Join Date
    Mar 2006
    Posts
    2

    Here is an example of a file

    "Picking Ticket","ORD00349","Fulcrum Health Products, LLC"
    "Document Date","3/30/2006","2523 Wayzata Blvd."
    "Page","1","Suite 300"
    "Who Printed","am","Minneapolis MN 55345"
    "Date Time Printed","3/30/2006","10:11:34 AM"
    ""
    "Bill To:","Ship To:"
    "Ken's Hub City Cycle & Fitness","Ken's Hub City Cycle & Fitness"
    "425 Lincoln Highway","425 Lincoln Highway"
    "Rochelle IL 61068","Rochelle IL 61068"
    "",""
    "Purchase Order No.","Customer ID","Salesperson ID","Shipping "Method","Payment Terms","Req Ship Date"
    "","KEN'S HUB CITY","PATRICIA","","Credit Card","3/30/2006"
    "Item Number","Description","Pick Qty","UOM","Qty Picked"
    "515-1602","Tour Black Small","1","EACH","________"
    "515-1605","Tour Black Medium","1","EACH","________"
    "515-1608","Tour Black Large","1","EACH","________"
    "515-2402","Tour Blue Small","2","EACH","________"
    "515-2405","Tour Blue Medium","2","EACH","________"
    "515-2408","Tour Blue Large","2","EACH","________"
    "515-2409","Tour Blue X-Large","1","EACH","________"
    "515-3205","Pro Black Medium","2","EACH","________"
    "515-3208","Pro Black Large","1","EACH","________"
    "515-3209","Pro Black X-Large","1","EACH","________"
    "2005-02","Heatwave - Medium","2","EACH","________"
    "2005-03","Heatwave - Large","2","EACH","________"

  4. #4
    Join Date
    Dec 2005
    Location
    Wilmington, DE - USA
    Posts
    275
    1. Which data elements get imported?
    2. Where do they go?

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

Similar Threads

  1. Upload file inside .mdb database file
    By havish in forum Access
    Replies: 0
    Last Post: 07-30-2008, 07:35 AM
  2. Possible to export *.mdb file to *.exe file?
    By slpuiwan in forum Import/Export Data
    Replies: 1
    Last Post: 12-16-2007, 06:52 PM
  3. Validation on import
    By andy_42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-23-2006, 03:52 PM
  4. How do you export a file with a unique file name
    By Budman42 in forum Import/Export Data
    Replies: 1
    Last Post: 10-15-2006, 06:10 PM
  5. IMPORT ERROR ..PLEASE HELP
    By fadone in forum Import/Export Data
    Replies: 2
    Last Post: 04-20-2006, 06:36 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