Consulting

Page 2 of 2 FirstFirst 1 2
Results 21 to 27 of 27

Thread: split data into individual groups

  1. #21
    VBAX Regular
    Joined
    Apr 2005
    Posts
    20
    Location
    looks great - how can I add the heading on each CSV?

  2. #22
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    What do you mean by "Heading"?
    Do you mean feild names?

  3. #23
    VBAX Regular
    Joined
    Apr 2005
    Posts
    20
    Location
    sorry - feild names please


  4. #24
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    After this line

    Open "C:\Access Databases\" & groupname For Output As #1

    paste in this line of code

    Write #1, "First Name, Last Name, UserName, Group" & vbLf

  5. #25
    VBAX Regular
    Joined
    Apr 2005
    Posts
    20
    Location
    looks great - just a question when I open the CVS in Excel the field names are in cell a1 and the othe data in cell b1 and so on - see screen shot.ScreenShot014.bmp

  6. #26
    VBAX Guru
    Joined
    Mar 2005
    Posts
    3,296
    Location
    That is normal for CSV, you have to parse the data using Excel's Data> Text to Columns.
    Or you use a Data>import from text to convert it as it cis imported.

  7. #27
    VBAX Regular
    Joined
    Apr 2005
    Posts
    20
    Location
    thank you - have a great weekend

Posting Permissions

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