#1
  1. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Okay, just looking for some info
    on CSV files....

    specifically speaking, I would like to see a csv file exported from MS Excel.

    I have thus far seen a couple different csv's from a couple of different programs, and in both cases they were rather different.

    One exported from InfoSelect 4:
    first row: field names
    all other rows: field data

    One exported from another program
    just field data

    I'm really curious as to how excel exports csv's..

    also, can someone tell me what file extensions are specifically used
    for Access, and what formats can Access export to?

    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.
  2. #2
  3. No Profile Picture
    Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    Seaside, CA
    Posts
    84
    Rep Power
    15
    You can export from Excel or Access as delimited text files, or csv. There are several choices as to the delimiter.

    Here's an example from an Excel worksheet (comma delimited):

    WEEK,DATE,COLLECTED,BOTTLE ,SAMPLING,SAMPLE,TOTAL,E. coli,,
    NO.,COLLECTED,BY,NUMBER,POINT,TYPE,COLIFORM,,,
    1,01-May-00,Duplissie,1,121 Brookside Place,Routine,Absent,Absent,,
    ,01-May-00,Duplissie,2,3020 King Circle,Routine,Absent,Absent,,
    ,01-May-00,Duplissie,3,3162 Crescent Avenue,Routine,Absent,Absent,,

    I just found, but haven't tried an automated csv dump program at http://oss.gospelcom.net/

    Also, if you get MyODBC, and your server allows it, you can connect to a MySQL database with Access.

    I think this was one of the links I found it at: http://www.iserver.com/support/addon.../msaccess.html

    The easiest and quickest non-automated way I've found to get csv/text (some type of delimited file) into and out of MySQL is phpMyAdmin, which is at phpwizard.net.

    Whew! That's just a start.


    ------------------
    From the day we're born, we're running out of time.
  4. #3
  5. No Profile Picture
    Robert_J_Sherman
    Guest
    Devshed Newbie (0 - 499 posts)
    Joel,

    Thanks for the response, and answers.
    I'm a firm believer in PHP myAdmin, wizards really did well with it.

    Any way, I'm going to bounce out and look at these, well cept for myadmin, I have it..



    ------------------
    SnR Graphics,
    Low Cost Hosting and Web Development.

Similar Threads

  1. Can't move or delete it!
    By Hykinsel007 in forum Windows Help
    Replies: 3
    Last Post: June 15th, 2004, 04:41 PM
  2. Reading files that has certain parrent at once
    By cgi_pro in forum Perl Programming
    Replies: 2
    Last Post: January 29th, 2004, 11:13 PM
  3. how to rename files
    By dxgn in forum Perl Programming
    Replies: 1
    Last Post: January 1st, 2004, 02:10 PM
  4. How can I pack servlet files into a jar file?
    By suryahema in forum Java Help
    Replies: 1
    Last Post: December 18th, 2003, 09:32 AM
  5. DB design - flat files or in a table
    By persaltier in forum Database Management
    Replies: 1
    Last Post: December 12th, 2003, 09:39 PM

IMN logo majestic logo threadwatch logo seochat tools logo